If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hyperlink to specific worksheet in Excel
I tried asking this a few weeks back but did not get an answer that worked.
I am trying to create a hyperlink on a web page that when clicked it will open a specific worksheet of a specific Excel document. The Excel document I have has 9 worksheets on it - ultimately I want to have 9 different hyperlinks that will open the document to each sheet as desired by the clicker. In looking around I found some references that seemed to say this would work with the following syntax types: a href=file://server/ReportOutput/MyFile.xls#Sheet9 Click /a OR a href=file://server/ReportOutput/MyFile.xls#'My Sheet'!A1 Click /a I have office 2003. Perhaps this used to work in order versions of Excel? At the moment, when this is clicked on it only opens to either sheet 1, or whatever sheet it was last saved with on top, not the requested worksheet. Any help is appreciated. -- Glenn |
#2
|
|||
|
|||
Glen --
Ditto ... I'm having the same issue PLUS now on my work computer, I can't get the hyper-links to even open a specific file ...it just opens a dialog box ( directory listing ) of the directory for the file I hyperlinked to and won't even open the file now. If you find a fix ... please post it ! Thanks, Mark "Glenn Mulno" wrote in message ... I tried asking this a few weeks back but did not get an answer that worked. I am trying to create a hyperlink on a web page that when clicked it will open a specific worksheet of a specific Excel document. The Excel document I have has 9 worksheets on it - ultimately I want to have 9 different hyperlinks that will open the document to each sheet as desired by the clicker. In looking around I found some references that seemed to say this would work with the following syntax types: a href=file://server/ReportOutput/MyFile.xls#Sheet9 Click /a OR a href=file://server/ReportOutput/MyFile.xls#'My Sheet'!A1 Click /a I have office 2003. Perhaps this used to work in order versions of Excel? At the moment, when this is clicked on it only opens to either sheet 1, or whatever sheet it was last saved with on top, not the requested worksheet. Any help is appreciated. -- Glenn |
#3
|
|||
|
|||
Here's the solution:
First you have to set up the Excel document first by creating an "anchor": 1. Open the Excel document to the worksheet you want to link (ie. exceldocument.xls) to the select cell A1 2. Go from the file menu go to INSERT Name Define 3. Type in a short name with only letters and numbers no spaces (ie. myanchor) and then click OK 4. Save you Excel document Now you can create your link: 5. The URL should be your excl document #(your defined name). For the example above it would be exceldocument.xls#myanchor or if you need to see the whole tag it would be a href="exceldocument.xls#myanchor" Voila! I've test this and it works properly. Starturtle |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
hyperlink an excel cell to a specific location wthin application f | dirtboy | New Users | 1 | January 17th, 2005 08:07 PM |
Hyperlinking to Specific Excel Worksheet | Darryl | General Discussion | 1 | August 27th, 2004 10:16 AM |
Extracting Excel Worksheet from Word Doc | Suzanne | General Discussion | 1 | August 16th, 2004 09:58 PM |
Linking from Powerpoint to a specific Excel worksheet | Malcolm North | Links and Linking | 3 | June 25th, 2004 07:10 PM |
Excel 2000 - Worksheet Protection Problem | Norman Harker | Worksheet Functions | 1 | February 18th, 2004 08:58 AM |