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