Try using File / Properties and setting Hyperlink Base to some
non-existent server name like \\JunkServer\JunkDirectory

That should force the hyperlink to be held in full rather than relative
to the hyperlink base, which sometimes causes problems.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup