Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink worksheet data to a index in a workbook?
I have created a workbook with multiple worksheets for vehicle maintenance
and a master index. I am trying to hyperlink them to an index page in this workbook and when I do it comes up cannot open specified file. So there has to be a way to do what I am tring to do, because I have done this before but this time it does not seem to be working. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink worksheet data to a index in a workbook?
Try with HYPERLINK() function
=HYPERLINK(Sheet3!A1,"Friendlyname") If this post helps click Yes --------------- Jacob Skaria "tb" wrote: I have created a workbook with multiple worksheets for vehicle maintenance and a master index. I am trying to hyperlink them to an index page in this workbook and when I do it comes up cannot open specified file. So there has to be a way to do what I am tring to do, because I have done this before but this time it does not seem to be working. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink from one worksheet to another workBOOK | Excel Discussion (Misc queries) | |||
can I 'hyperlink' within a workbook from the first worksheet? | Excel Worksheet Functions | |||
Hyperlink to worksheet in other workbook | Excel Discussion (Misc queries) | |||
can I hyperlink to a worksheet tab in workbook saved as html? | Excel Discussion (Misc queries) | |||
Hyperlink to another worksheet in the same workbook | Excel Discussion (Misc queries) |