3

MS Excel 2010 is not updating formulas. For instance, I have this formula in cell D2:

=A2 + B2

If I put data in A2 and B2, D2 does not show the result.

However, if I enter values in cells A2 and B2 first 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 A2 or B2, D2 does not get updated.

Can you help me ?

Improve this question
2
  • What do you mean by "if I first fix the value of cell A2 and B2"
    – Dave
    Commented Jul 18, 2012 at 14:03
  • 2
    Are you on automatic calculation mode: File > Excel Options > Formulas > Calculation options > Automatic?
    – assylias
    Commented Jul 18, 2012 at 14:14

2 Answers 2

Reset to default
3

Are your Calculation Options set to Manual? If they are, set them back to Automatic.

enter image description here

Improve this answer
1

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.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .