Hyperlinks breaking when save/reopen file...

[taylorj]

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

 

[Dave Peterson]

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\Validation\HSP22-ValKPIs.xls",
"click me")

(all one cell)

 

[taylorj]

Thanks - using the Hyperlink function seems to have worked.

Great!

J