#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 68
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Relative Hyperlinks

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
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 68
Default Relative Hyperlinks

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlinks - relative references [email protected] Excel Discussion (Misc queries) 2 October 4th 07 05:32 PM
Relative and absolute hyperlinks Musette New Users to Excel 2 October 4th 07 06:47 AM
Relative Hyperlinks to local files CR Optiker Links and Linking in Excel 3 April 5th 06 06:05 AM
Relative Hyperlinks are not saved correctly PH at IUMG Excel Worksheet Functions 0 October 4th 05 08:38 PM
Relative Hyperlinks to PDFs (or other documents) || cypher || Excel Discussion (Misc queries) 1 November 30th 04 04:05 AM


All times are GMT +1. The time now is 07:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"