hyperlink will not follow when worksheet changes name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anybody tell how I can change the name of a worksheet (Tab) within a
Excel workbook and have the hyperlink recognize the name change of the tab.
 
I'd use the =hyperlink() worksheet function.

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)
 
Say you have inserted in Sheet1 a hyperlink to Sheet2 cell Z100. If you
change the name of Sheet2, the hyperlink on Sheet1 will no longer work. The
name will not adjust.


There is an easy work-around. Select Z100 in Sheet2 and insert a Defined
Name. Say alpha. Go back to Sheet1 and insert a hyperlink, this time to
alpha. The hyperlink will work and will continue to work even if you change
the name of Sheet2.
 
I have tried to place a defined name within the specific cell I want the
hyperlink to go to, but it still will not let me change the name of the
sheet. do you think it could be that the hyperlink references a cell within
the same worksheet. here the hyperlink formula, and cell A731 is what it
point to and I have given cell A731 a defined name any other suggestions.
=HYPERLINK("#'CC (1)'!A731","EBITA")
 
Open a new, blank workbook

1. Go to Sheet2
2. Select Z100
3. Insert > Name > Define and enter alpha
4. Go to Sheet1
5. Select A1
6. enter:
=HYPERLINK("#alpha","Jackson")

If you click on this link you will goto Sheet2 Z100.
If you re-name Sheet2 to any other name, the hyperlink on Sheet1 will
continue to work.
 
Back
Top