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.

For some reason all of a sudden when I update cells in Excel, my equations are not being updated. For example, I have a simple equation =SUM(C4:C16). If I change any of the cells in C4-C16, the answer doesn't get updated... I don't know what happened I've never seen this fail before. Any ideas?

share|improve this question
add comment

5 Answers

up vote 3 down vote accepted

Check to make sure Automatic Calculation is still selected. Go to Formulas->Calculation->Calculation Options and select "Automatic".

share|improve this answer
add comment

Usually changing the "Workbook Calculation" option (Excel 2010) solves the problem, but if it didn't, probably the workbook itself is set to manual calculation. To change this, open the workbook, select the "Formula" tab (Alt+M), then click "Calculation Options" and the select "Automatic". Now save the workbook.

share|improve this answer
add comment

Try changing the format type of the calculated cell from "Text" to "General" and then re-enter the formula. That fixed the problem when I was seeing these symptoms.

share|improve this answer
add comment

I think this can happen when you end up with different data types in the fields in the given range. Can you check and make sure the data in there is all still numerical? I think I've noticed this happening for me when I threw in a value once that was "$xyz" as opposed to "xyz" (I mean xyz to be some integer, of course).

share|improve this answer
add comment

It's like it gets stuck. I suggest you copy your formula into Notepad, then type any number into the cell. After that, click on the cell and paste your formula into the formula bar and hit enter. That resolved the problem for me.

share|improve this answer
add comment

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.