A link between two workbooks doesn't keep the value, shows #value
As I said, some formulas are just too complicated for Excel to compute
on a closed file.
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|