Formula Updates

[markbp49]

I opened a spreadsheet and the formulas are not updating. Example.

A1=5
A2=10
If Itype in A3 the formula =A1*A2, the result will be zero. Another problem, if D4 has a value of 200 and their is a formula that says, =D1*D2. And if D1 is 50 and D2 is 4, if I change D2 to 2, the formula result will still show 200 instead of changing to 100. Any ideas? I have tried looking at the automatic calculation, hitting F9 and also changing the cell format. Thanks.

[Paul]

If Calculation is set to automatic then...

1. Are there any worksheet_change events being triggered?
2. Is your worksheet corrupt?

After you change D2 to 2, select D4 and press F2 then Enter. Does that update the formula result?