Hyperlink to renamed Worksheet fails
 

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.

Hyperlink to renamed Worksheet fails
 

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.
--
Gary''s Student - gsnu200798


"KIM W" wrote:

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.

Hyperlink to renamed Worksheet fails
 

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),sheeton e!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.

KIM W wrote:

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.

--

Dave Peterson