The formula will not update even though automatic caculation is selected.
Your macro apprears to be working so far. Thank you very much. It seem that
this is a bug in Excel that won't auto update the calculation. This problem
has stumped many people. Your solution is the best I've seen so far.

Thanks again,
Chance

"Bill Manville" wrote:

Which version of Excel?

Does the formula work even though it looks wrong (ie if you update the
source cell does the destination cell also change, assuming automatic
calculation mode)?

If you have Excel 2002 or later try running this macro:

Sub Mend()
Application.CalculateFullRebuild
End Sub

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