Hyperlinks breaking when save/reopen file...
 

This has been bugging me for ages, and now I've found you guys on the
forum I'm hoping you can help me with a fix!

I have a file with multiple hyperlinks to project files, all of which
are on a network share.

When created the hyperlinks work perfectly:-
\\vault\sisnetdev\Projects\HSP22\Validation\HSP22-ValKPIs.xls

As soon as I then save, close, and reopen the file the hyperlink path
changes to :-
../../../../sisnetdev/Projects/HSP20/Validation/HSP20-ValKPIs.xls

I've tried adding the "file://" to the front, both direction of \ or /
and no difference.

I've ended up writing "fix hyperlinks" button which replaces the
../../../../ with \\vault\, but this is a pain to have to keep
running....

Any ideas??

Cheers,

Julian


--
taylorj
------------------------------------------------------------------------
taylorj's Profile: http://www.excelforum.com/member.php...o&userid=32856
View this thread: http://www.excelforum.com/showthread...hreadid=526678

Hyperlinks breaking when save/reopen file...
 

Just a guess...

Try changing the hyperlink base
(file|properties|Summary tab|Hyperlink base)
to a path that always exists (C:\ ???).

Maybe the links won't be changed.

But my preference is to use the =hyperlink() worksheet function.

=hyperlink("\\vault\sisnetdev\Projects\HSP22\Valid ation\HSP22-ValKPIs.xls",
"click me")

(all one cell)


taylorj wrote:

This has been bugging me for ages, and now I've found you guys on the
forum I'm hoping you can help me with a fix!

I have a file with multiple hyperlinks to project files, all of which
are on a network share.

When created the hyperlinks work perfectly:-
\\vault\sisnetdev\Projects\HSP22\Validation\HSP22-ValKPIs.xls

As soon as I then save, close, and reopen the file the hyperlink path
changes to :-
./../../../sisnetdev/Projects/HSP20/Validation/HSP20-ValKPIs.xls

I've tried adding the "file://" to the front, both direction of \ or /
and no difference.

I've ended up writing "fix hyperlinks" button which replaces the
./../../../ with \\vault\, but this is a pain to have to keep
running....

Any ideas??

Cheers,

Julian

--
taylorj
------------------------------------------------------------------------
taylorj's Profile: http://www.excelforum.com/member.php...o&userid=32856
View this thread: http://www.excelforum.com/showthread...hreadid=526678

--

Dave Peterson

Hyperlinks breaking when save/reopen file...
 

Thanks - using the Hyperlink function seems to have worked.

Great!

J


--
taylorj
------------------------------------------------------------------------
taylorj's Profile: http://www.excelforum.com/member.php...o&userid=32856
View this thread: http://www.excelforum.com/showthread...hreadid=526678