Thanks. But there was nothing in the Hyperlink base field. It was blank.

"Bill Manville" wrote:

The hyperlinks are being stored as relative.
To get them stored as absolute, open the workbook in Excel (while it
still has its links to the correct network share),
File Properties Summary Hyperlink base: \\NoServer\NoFolder
(or any other non-existent location).


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