Try
File Properties Summary Hyperlink Base: \\NoServer\NoFolder
(or any folder that either doesn't exist or is unrelated to the files
you want to reference).

I think that then any hyperlinks you create will be stored as full
paths rather than relative to the folder containing the workbook.

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