Hyperlink Copy Error

[PhilosophersSage]

When hyperlinking a file in excel I use \\Server/folder/folder/file.xxx or
\\Server\folder\folder\file.xxx however when the file is saved the link
changes to ../../folder/folder/file.xxx the problem comes when I either copy
the cell with the hyperlink or copy the file the hyperlink will no longer
work gives error “The address of this site is not valid. Check the address
and try again.†Any suggestions as how to maintain the hyperlink integrity?
Thank you for any suggestions.

 

[Gary''s Student]

Use the =HYPERLINK() formula rather than Inserted hyperlinks

 

[Dave Peterson]

A few people have said that this has resolved the problem for them:

File|Properties|Summary Tab|Hyperlink Base
change it to C:\
(something that's always available)

I like to use the =hyperlink() worksheet function. It has never failed me this
way:

=hyperlink("file:////yourpathtothe/something.xxx","Click me")

 

[PhilosophersSage]

Tried =HYPERLINK() and it does not work as some of my files have a dash "-"
in them due to file nameing standards, we cannot use a drive "C:\" as it is a
network resorce and must use UNIMAP address as we span many locations and
many servers.

 

[PhilosophersSage]

Changeing the Hyperlink base to the UNIMAP server did work I was doing it
wrong the first time. Thank you!

 

[Alireza Nejad]

Could you please elaborate more? i have the exact same problem and i dont
understand how you fixed it. Thanks

 

[Diego Carrasco]

Go To File, Properties, Summary label, Hyperlink Base
Write the path to the folder where your original file was (the file where
the hyperlinks were created)
All the hyperlinks of that file will be opened from that base folder, and
not the folder path of the current location of the file.
In excel 2007, access to File Properties by: Office Icon, Prepare,
Properties, Document Properties, Advanced Properties, Summary label,
Hyperlink Base

Regards