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

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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question