Links will almost always work if the source workbook is open (unless
the destination workbook has a broken calculation tree - hence the
Ctrl+Alt+F9 suggestion).

There are a number of possible reasons for problems with links when the
source workbook is closed, but we have already eliminated some of
those. I will look at the workbooks when I get them.

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