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
|