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

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.

About these ads
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.

  1. May 31, 2012 at 15:15

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 1,663 other followers

%d bloggers like this: