hyperlink changes after save

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

news.microsoft.com - 04 Oct 2007 12:30 GMT

hello,

in office 2003 we have the problmem that when we make a hyperlink, to a
share in our nw, it works fine, but when we save the sheet, it doesn't
anymore.
Can someone help us out?
tx.
N.

from the working hyperlink
\\ts\homedir$\wim.de.smet\diskette 2\MVC-002F.JPG

to this after we saved

../../../../homedir$/wim.de.smet/diskette%202/MVC-002F.JPG

Reply to this Message

Dave Peterson - 04 Oct 2007 13:37 GMT

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.jpg","Click me")

> hello,
>
[quoted text clipped - 11 lines]
>
> ../../../../homedir$/wim.de.smet/diskette%202/MVC-002F.JPG

Signature

Dave Peterson

Reply to this Message