Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Senior Coder
    Join Date
    Jun 2002
    Location
    Zwolle, The Netherlands
    Posts
    1,120
    Thanks
    2
    Thanked 31 Times in 31 Posts

    Linking to a position in an excel sheet

    Hi,

    I am working in an environment where reports can be generated as html-output. So i have absolutely no control over the html that is produced. What i want is to link to an excel sheet, to be more exact, i want to link to a certain position in the sheet. What i've tried is the following. Naming a cell in excel and then setting the href for the link (this is the only thing i can determine myself) as "drive:\folder\sheetname.xls#cellname" this works on my machine (NT-workstation, IE5,5) but it doesn't work on the machine of other people in the same company, same OS, same browser. What setting do i have to adjust in the browser or OS so it will work on other machines too??

    Roelf
    I am the luckiest man in the world

  • #2
    Senior Coder
    Join Date
    Jun 2002
    Location
    Zwolle, The Netherlands
    Posts
    1,120
    Thanks
    2
    Thanked 31 Times in 31 Posts
    hmmm, maybe i should explain better what goes wrong exactly

    on one machine, a new browser window is opened, where the sheet is opened in the browser window, changing the window interface to an excel like interface. In that case the link brings us to the desired position in the sheet.

    on the other machine i get an automatic download screen for a very short time, the sheet is downloaded and excel is started with the sheet loaded. In that case the cell-pointer is at the same position as where it was when i saved the sheet.

    Please let me know what i should/could do to make it work on all machines
    I am the luckiest man in the world


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •