Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to create hyperlinks to other sheets in the same book. When I
click on the link, I receive File not found. I followed the instructions in help with no success. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Since you didn't say which instructions you followed (there's more than
one way to create a hyperlink), it's hard to say what went wrong, but one way to do it: 1) Select the cell to contain the hyperlink. 2) Choose Insert/Hyperlink 3) In the Link to: box, enter an octothorpe followed by the sheet and cell reference. For instance, for worksheet Sheet3, cell J10: #Sheet3!J10 4) Enter any display text in the Display: box 5) Click OK. In article , Dgwood90 wrote: I am trying to create hyperlinks to other sheets in the same book. When I click on the link, I receive File not found. I followed the instructions in help with no success. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You could also use the =hyperlink() worksheet function:
David McRitchie posted this and it might help you: =HYPERLINK("#"&CELL("address",C5),C5) =HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5) =HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5) Dgwood90 wrote: I am trying to create hyperlinks to other sheets in the same book. When I click on the link, I receive File not found. I followed the instructions in help with no success. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto Rename Excel Sheets in Workbook | Excel Worksheet Functions | |||
CREATE NEW WORKBOOK AND SHEETS BASED ON COLUMN DATA | Excel Worksheet Functions | |||
hyperlink tospecific sheet of html workbook | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions |