Hyperlinks opening an Excel file at a particular tab

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Oversensitive touchpad on modern laptops 0
Activating hyperlinks 3
Folder/Tabs Newbie Question 2
Excel Files Won"t Open Automatically 2
Will not auto open .jpg 1
Linking Excel Files 2
Excel Unlink open excel files 2
Link 2 Excel files 6

Back
Top