Cell does not automatically reflect the result of a formula
Are your Calculation Options set to Manual? If they are, set them back to Automatic.
Set Calculations to Automatic in Formulas > Calculation Options > Automatic for excel to update contents of formulas automatically.
If you don't want automatic calculations but want to trigger a calculation after values are changed press the "Calculate Now" button of F9.
Related videos on Youtube
Vellarad 2 months
MS Excel 2010 is not updating formulas. For instance, I have this formula in cell
=A2 + B2
If I put data in
D2does not show the result.
However, if I enter values in cells
B2first BEFORE I enter the formula in
D2, it shows the result, but the formula only seems to work "once." If I change the values in either
D2does not get updated.
Can you help me ?
Dave over 10 yearsWhat do you mean by "if I first fix the value of cell A2 and B2"
assylias over 10 yearsAre you on automatic calculation mode: File > Excel Options > Formulas > Calculation options > Automatic?