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.

Excel is not working correctly for me. When I change the input of a formula, the output is not automatically updated. Could this be due to a virus? How do I get Excel to update formulas automatically again?

share|improve this question
5  
No, it's not a virus. –  SLaks Oct 30 '12 at 23:36

3 Answers 3

If it is, this sounds like one of the most annoying viruses in the world!

No, most likely you simply have calculations set to Manual, or something else similar such as an add-in, macro or extension e.t.c. that is interfering with the normal operations of Excel.

To check for the easiest one, go to Formulas > Calculation Options, and make sure it is set to Automatic

enter image description here

share|improve this answer

I had trouble getting formulas to update, until I realised some cells had formatting applied (formatted as Text I think?). Fixed by right-clicking on the cell, selecting Format Cells... and choosing General under Category.

share|improve this answer

I had same issue (formulas was manual). So I used the fill to drag an average or sum and it dragged the value, rather than calculating the new columns. Fixed with the setting. Never saw that before, wonder if it was because I have a new build or because I occasionally use a spreadsheet that has a complex set of formulas and has a "calculate now" button that you hit to run chart output.

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.