Some formulas are too complex for Excel to evaluate without opening the
source workbook. I would recommend that you open the source workbook,
which could be done for example in an Auto_Open macro.

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