Hyperlink issues


G

Guest

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
 
Ad

Advertisements

D

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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top