Hyperlink updates within same worksheet

[Guest]

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!

 

[Anne Troy]

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/named_ranges_in_microsoft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com