Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating Link to specific Sheet in external excel file
I am trying to create a hyperlink from one excel file (so you just have to
click on it) and it will open up the referenced excel file, but more specifically will open the file to the certain sheet you want it to open to. Is this possible, and if so what is the code or shortcut to get this to work? Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating Link to specific Sheet in external excel file
This worked to open book2.xls and go to A1 of sheet1:
=HYPERLINK("file:////c:/my documents/excel/book2.xls#sheet1!a1","click me") cmceng14 wrote: I am trying to create a hyperlink from one excel file (so you just have to click on it) and it will open up the referenced excel file, but more specifically will open the file to the certain sheet you want it to open to. Is this possible, and if so what is the code or shortcut to get this to work? Thanks, -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a virtual link in Excel | Excel Discussion (Misc queries) | |||
Cannot save external data into file excel system show not respondi | Excel Discussion (Misc queries) | |||
Insert & link a graphic file in Excel 2003 -- updatable pictures! | Excel Discussion (Misc queries) | |||
auto file path update when excel sheet moved to another directory. | Excel Discussion (Misc queries) | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel |