Hyperlink to renamed Worksheet fails

[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.

 

[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.

 

[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.