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

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?

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


"AKennedy" wrote in message
...
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?

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



AKennedy wrote:

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?

--

Dave Peterson