Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hyperlinks opening an Excel file at a particular tab
Dear All,
One of my colleagues wants to create multiple links on a website to ONE Excel spreadsheet and get it to open the appropriate tab, ie click on the first link and it opens myfile.xls at tab 1, click on another link and it opens the same file but on another tab, etc. Any ideas?? TIA Patrick |
#2
|
|||
|
|||
If you are using Insert-Hyperlink to create the hyperlink then you can add
the following to the address. myfile.xls#tab_1 This should allow you to link to each separate tab. Good luck pootonline -- You can never know it all "PatrickW" wrote: Dear All, One of my colleagues wants to create multiple links on a website to ONE Excel spreadsheet and get it to open the appropriate tab, ie click on the first link and it opens myfile.xls at tab 1, click on another link and it opens the same file but on another tab, etc. Any ideas?? TIA Patrick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
Saving a Excel 97 file into Excel 2003 file | Excel Discussion (Misc queries) |