How can I stop Excel 2003 from changing my hyperlinks on close?

[Guest]

I have a document with links to files on a shared network drive. On one
computer the links get changed to local links on close. EG.

I link to \\server\myfile
It works fine till I close and I get
/../../../myfile

What is going on?

 

[Dave Peterson]

A couple of people have posted that setting the hyperlink base will stop this
"helpful" behavior.

File|properties|summary tab
Hyperlink Base: C:\

(C:\ should be available)

 

[Dave Peterson]

Ps. I like to use the =hyperlink() worksheet function. It behaves much nicer.