Home > Work > Excel formulas not auto calculating but F9 still works #in

Excel formulas not auto calculating but F9 still works #in

As ever, when you work in IT you become the go to guy / gal for friends, family etc…

So today, whilst working on my TechEd Europe 2012 presentation, my girlfriend rang up, asked if I knew Excel and promptly forward me to a manager for a quick chat.

The problem

Excel is no longer auto calculating formulas for any spread sheet that is opened, yet if you press F9, suddenly the calculations kick into touch.

The solution

Essentially, automatic calculations have been turned off in the Excel client and we simply need to turn it back on again:

Excel 2003

  • Menu: Tools > Options
  • Click on the Calculation Tab and on the checkbox labelled Automatic, check it and click OK.

Excel 2007 / 2010

  • Click on the Formulas ribbon
  • Dropdown Icon: Calculation Options
  • Check: Automatic


Problem solved Smile

Now you may be wondering what this is doing on a SharePoint (and Project Server) blog. 

Well mostly it has nothing to do with the applications in this case, but you may just start pulling your hair out whilst working on an Excel Services spread sheet… you never know when this might come in handy.

Categories: Work Tags:
  1. anonymous
    September 21, 2012 at 10:37

    Thank you Giles, as I had the similar kind of problem, and this was the right solution.

  2. David
    March 21, 2016 at 16:45

    I’ve been using Office 365 for a year and working Excel on a beginner level. All of a sudden basic calcs between cells are not computing. =A2*1.25 gives me an error message, does anyone know how to help me resolve this problem

    • March 26, 2016 at 03:14

      Hi David, have you confirmed the cell format is not set to text?

  3. June 8, 2016 at 10:15

    It came in real Handy today!! Thank you

  1. May 31, 2012 at 15:15

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: