Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink issues | Excel Discussion (Misc queries) | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
PDF hyperlink issues | Excel Discussion (Misc queries) | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
Update links - hyperlink issues | Excel Discussion (Misc queries) |