Why do hyperlinks change folder paths while maintaining the file name when I
copy/paste the links from workbook to workbook?
I have tens of thousands of hyperlinks in a workbook and I am reconfiguring
the entire workbook to a new workbook but all the links become broken after
copy/paste to the new workbook. The location becomes the computer users
default "My Documents" location.
Example:
Original hyperlink: (Server, which is available to all internal PC's)
M:\Some Folder\Specs\Myfile.pdf
Becomes, after copy/paste to new workbook:
C:\Documents and Settings\User\My Documents\Specs\Myfile.pdf
Of course the file is still in its original location.
The text "Specs\Myfile.pdf" is the only portion of the link that is valid
after copy/paste.

How can I prevent this?

--
Regards

Rick
XP Pro
Office 2007