I have a problem with hyperlinking within an Excel 2003 document. The properties of the hyperlink seem to change when the document is saved. So instead of the q:\document path\document name, it changes to ../../document name. Every time the document is saved it seems to add an additional ../ to the front of the document path. This results in the hyperlink becoming invalid.
Things we have tried to resolve this …
Set the base URL path to Q
Other things to consider
The hyperlinks are to other word and excel documents on the base Q drive and also to documents stored on S & T drives. The mapped drives are the same for everyone.
We are mapped to the root of the share, not a subfolder (I've seent the MS document about that)
The document is password protected and only 2 people can save this document. They both run Excel 2003.
There are thousands of hyperlinks in the document. I’m aware that using the =hyperlink or manually typing in \\servername\sharename\documentpath would change the default save behavior and it would not then alter the links but the work involved would be prohibitive.
Could you offer some advice on the best way forward for fixing the existing problem and preventing it from reoccurring.