Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

After an upgrade from Excel 2003 to 2007, suddenly auto-calculate does not work any longer. If the user hits F2 it will correctly update all fields. Also, the calculation mode is correctly set to Automatic. Could this be a macro issue? Really not sure what's going on.

share|improve this question

Check the "Excel Options" button from the windows office circle thingy. That will bring up a new dialog box. Down the left side will be a "Formulas" item. Select it and then you will be graced by the caluclations stuff. Make sure "Automatic" is selected.

Share and enjoy.

share|improve this answer
As noted in the question, calculation is set correctly to Automatic. :) – jasonjwwilliams Feb 9 '10 at 20:05
That will teach me to read! :) – Craig Feb 10 '10 at 15:44
up vote 1 down vote accepted

Re-installing Excel 2007 after uninstalling it completely fixed the issue. Must have been a clash of libraries left over from Excel 2003.

share|improve this answer

Your Answer


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.