Excel Hyperlinks on Server mapped to other shares dont work.

[Guest]

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

 

[Dave Peterson]

You could try this:

Open your workbook
File|Properties|Summary tab
try changing the hyperlink base to C:\

If it works, please post back.

===
I always had much better luck with hyperlinks by using the =hyperlink()
worksheet function.

Excel would never change those.

=hyperlink("file:////server1/share1/folder1/folder2/filename.xls")

 

[Guest]

wow this actually worked thank you been trying to fix this problem forever.

 

[Dave Peterson]

Thanks for posting back.

wow this actually worked thank you been trying to fix this problem forever.

 

[Guest]

Dave,
I know you wrote this message awhile back but I had to write and thank you!
This will save me a huge headache. I kept write the long path to the file
but when I saved the file the path would be saved as relative... I couldn't
send the file to a coworker---even tho the file is on a share drive. Now
that I have learned the hyperlink function I am HAPPY!

again,
thanks
Belinda

 

[Dave Peterson]

Glad it worked for you!

Dave,
I know you wrote this message awhile back but I had to write and thank you!
This will save me a huge headache. I kept write the long path to the file
but when I saved the file the path would be saved as relative... I couldn't
send the file to a coworker---even tho the file is on a share drive. Now
that I have learned the hyperlink function I am HAPPY!

again,
thanks
Belinda