Hyperlink issues

[Rick S.]

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

 

[Dave Peterson]

A few people have said that this has resolved the problem for them:

File|Properties|Summary Tab|Hyperlink Base
change it to C:\
(something that's always available)

I like to use the =hyperlink() worksheet function. It has never failed me this
way:

=hyperlink("file:////yourpathtothe/something.pdf","Click me")

You may want to consider using the UNC path instead of the mapped letter, too.

 

[Rick S.]

I have been fearing this!

Thanks for the info!

--
Regards

Rick
XP Pro
Office 2007