Hyperlink issues
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 |
Hyperlink issues
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. wrote: 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 |
Hyperlink issues
I have been fearing this!
Thanks for the info! -- Regards Rick XP Pro Office 2007 "Dave Peterson" wrote: 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. wrote: 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 |
All times are GMT +1. The time now is 09:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com