How do I prevent Excel from replacing path in hyperlink when saved

[Rico B. Raben]

I´ve created a hyperlink in a cell using the Insert Hyperlink option. I'm
using the path (F:\myfile.txt). When I save the document, the hyperlink
changes to (\\MyServer\MyPath\myfile.txt). Is it possible to prevent this,
because if the servername is changed in the future the link won't work

Regards Rico

 

[Gary''s Student]

Use the =HYPERLINK() function:

=HYPERLINK("F:\myfile.txt","myfile")

 

[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")

==============
If you have to change lots and lots and lots back...

You could use the code from David McRitchie's site:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm
look for:
Fix Hyperlinks (#FixHyperlinks)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

(If it's just a few, I'd do it manually.)

 

[Rico B. Raben]

Hi Gary and Dave

Thanks a lot for your answers - I will have a look soon as possible

Regards Rico