I don't know if it will help with this problem, but some problems with
relative links are solved by File Properties Summary Hyperlink
Base : \\SomeJunkServer\JunkFolder

This forces hyperlinks to the same server as the file is saved on to be
saved as absolute.

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