Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 ?

share|improve this question
    
What do you mean by "if I first fix the value of cell A2 and B2" –  Dave Jul 18 '12 at 14:03
1  
Are you on automatic calculation mode: File > Excel Options > Formulas > Calculation options > Automatic? –  assylias Jul 18 '12 at 14:14

2 Answers 2

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

enter image description here

share|improve this answer

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.