Hyperlink to renamed Worksheet fails

K

KIM W

What can I do to handle Hyperlinks to other worksheets when those worksheets
might be renamed, or even rearranged in sequence?
My current experience is that the Hyperlinks break when a target worksheet
is renamed.
 
G

Gary''s Student

Use a Defined Name as the target. For example, if Sheet1, cell B9 has been
given the name whereto, then in any other sheet:

Insert > Hyperlink > to a place in this document > and pick whereto.
 
D

Dave Peterson

I like to use a worksheet function that will adjust if the worksheet name
changes.

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

These formulas will adjust if you change the sheet name or insert/delete
rows/columns on the "sending" sheet.
 
Top