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

steve.a wrote:

I have a spreadsheet with around 1000 links to a network location, I need to
copy this info and spreadsheet to a cd to send to a european office, is it
possible to change the links automaticaly ? as to do it manually will take a
long time, thanks for any help offered

--
there are no problems just challenges

--

Dave Peterson