Why would hyperlinks in a spreadsheet change to an invalid path?
I created links in a spreadsheet to external Word docs stored on a shared
network drive. When I opened the spreadsheet today, the path had been changed to C:\Documents and Settings.... How can I prevent this from happening? |
Why would hyperlinks in a spreadsheet change to an invalid path?
Some people have said that if they change the hyperlink base
(file|properties|summary tab) to something that is always available (C:\ for instance), it can help stop those links from changing. Maybe it'll work for you. But that won't help fix the already messed up links. I try to use the =hyperlink() worksheet function. I've never seen them do anything bad. LisaW wrote: I created links in a spreadsheet to external Word docs stored on a shared network drive. When I opened the spreadsheet today, the path had been changed to C:\Documents and Settings.... How can I prevent this from happening? -- Dave Peterson |
All times are GMT +1. The time now is 11:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com