how to do global replace in hyperlinks for entire excel document?

[Guest]

had file restored and hyperlinks point to resotre location instead of
original location - is there a way to make the change to redirect to original
location for all links?

 

[JulieD]

Hi

AFAIK you'll need to use a macro for this, if you'ld like to type out a
couple of examples of the new hyperlinnk references and the old hyperlink
references we might be able to come up with something.

Cheers
JulieD

 

[Dave Peterson]

Just to add to JulieD's response:

Take a look at David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
look for:
Fix Hyperlinks (#FixHyperlinks)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm