Relative Hyperlinks

T

TKS_Mark

When sheets are renamed, the hyperlink should update with the renaming, the
same way formulas update.

Example: The original hyperlink is Sheet2!A1. When sheet2 is renamed to
sheet3, the hyperlink doesn't update with it and clicking on it gives a "the
reference is not valid" error.

It sure would be handy if hyperlinks updated when sheets are renamed.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...c-31c341e44cd1&dg=microsoft.public.excel.misc
 
D

Dave Peterson

You may want to replace the Insert|Hyperlink version of the hyperlinks with the
=hyperlink() worksheet function version.

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 linked sheet.
 
T

TKS_Mark

Thanks. That works better.

Dave Peterson said:
You may want to replace the Insert|Hyperlink version of the hyperlinks with the
=hyperlink() worksheet function version.

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 linked sheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top