hyperlinks
 

I have a spreadsheet with about 1000 hyperlinks, all the hyperlinks refer to
a network location containing subfolders, I wish to copy the folder to cd
along with the spreadsheet to send the info to an office in europe, is there
an easy way to update all the hyperlinks ? as to do each one manually would
take forever, any help appreciated

--
there are no problems just challenges