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