Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

You must log in to answer this question.

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