Why would hyperlinks in a spreadsheet change to an invalid path?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top