Hyperlink to another sheet, same workbook
 

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.

Hyperlink to another sheet, same workbook
 

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.

Hyperlink to another sheet, same workbook
 

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