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