View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Randaylb Randaylb is offline
external usenet poster
 
Posts: 5
Default Hyperlinks Shortened/Modified by Excel

I have a master file that references a multitude of other files. To link the
other files, I am using a hyperlink that looks like this:

\\company.com\SHARE\folder\document name.doc

This allows any user within the company to access the file. However, each
time I save the file and reopen it, the links have been changed to this:

.../../../../../../SHARE/folder/document%20name.doc

I noticed, too, that if I reference the file this way:

E:\SHARE\folder\document name.doc

....Excel changes it to the following:

document%20name.doc

(the master document is housed in the E:\SHARE\folder\ folder)

I presume there is a setting in Excel that attempts to change universal
links to local links; however, I have no idea how to correct the problem.
Suggestions?

R