Ok i'm about to open up a ticket with microsoft but i figured i would post
here first. here is the situation. we have a server lets call it server1. in
that server their are a bunch of shares lets call them share1, share2,
share3. and in the shares their are excel files and various other things. All
of our clients are now using office 2003. if i have a excel file and i save
it in \\Server1\share1\folder\file1.xls and i insert a hyperlink though any
method (i.e. typing it, browsing, whatever). to a file in the
\\server1\share1 directory everything works just fine. but if insert a
hyperlink to another share on server1 it doesn't work. so if i inserted a
hyperlink to \\server1\share2\folder2\file2.xls. it would not let me open the
hyperlink. it replaces the hyperlink with a realitive path. so so a hyperlink
inserted as in the example below would resolve to
...\..\share2\folder2\file2.xls. when it gets to the ..\ or (up a level
command) that repersents the root server i.e.(server1) it cannot resolved
that to the servers unc name and thus can't find any shares, folders, or
files located within it, and produces an error message. is their anyway to
either have excell always use absolute paths when inserting a new hyperlink
or in some other way fix that particular issue.



Server Structure
Server1
share1
folder1
ect
share2
folder2
ect