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.
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.
Essentially, automatic calculations have been turned off in the Excel client and we simply need to turn it back on again:
- 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
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.