Relative Hyperlinks

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/comm...lic.excel.misc

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

TKS_Mark wrote:
>
> 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/comm...lic.excel.misc

--

Dave Peterson

Thanks. That works better.

"Dave Peterson" wrote:

> 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),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 linked sheet.
>
> TKS_Mark wrote:
> >
> > 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/comm...lic.excel.misc
>
> --
>
> Dave Peterson
>