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 |
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 |
All times are GMT +1. The time now is 01:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com