Hyperlink change after email...
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
|