Hyperlink updates within same worksheet
 

I have several hyperlinks in Sheet1 to cells within the same worksheet. Is
there a way to update all the hyperlinks at once? I tried Edit Links
update hyperlinks, but that is only working for links to other worksheets.

Example B3 in Sheet1 hyperlinks to DD99 in Sheet1
I need to rename Sheet1 and update all the hyperlinks.

As always - I greatly appreciate this group and the help you give!

Hyperlink updates within same worksheet
 

Suggestion: Use named ranges to create your hyperlinks, then you can rename
your sheets all you want as long as the named range is still there. To name
a range, see:
http://www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"laralea" wrote in message
...
I have several hyperlinks in Sheet1 to cells within the same worksheet. Is
there a way to update all the hyperlinks at once? I tried Edit Links
update hyperlinks, but that is only working for links to other worksheets.

Example B3 in Sheet1 hyperlinks to DD99 in Sheet1
I need to rename Sheet1 and update all the hyperlinks.

As always - I greatly appreciate this group and the help you give!