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

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?

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)

blobaugh wrote:

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

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



blobaugh wrote:

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