A frequent reason for links showing #VALUE is if the workbook had been
saved using an earlier version of Excel than the one you are using.
Any help?

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