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

bnbbond wrote:

I had to move an excel file that I have over 200 hyperlinks to specific files
inside the same folders. The main hyperlink is common to all of the
hyperlinks, I need to know if there is a way I can do a search and replace a
piece of the hyperlink in excel. I'm using MS Excel 2003 SP1

--

Dave Peterson