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 
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.
SharePoint (and Project Server) Shenanigans 
Thank you Giles, as I had the similar kind of problem, and this was the right solution.
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
Hi David, have you confirmed the cell format is not set to text?
It came in real Handy today!! Thank you