Archive

Posts Tagged ‘Microsoft Excel’

Excel formulas not auto calculating but F9 still works #in

May 14, 2012 5 comments

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

image

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:
%d bloggers like this: