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

[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?

 

[Dave Peterson]

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.