Results 1 to 3 of 3

Thread: Excel loses "Automatic calculation" option

  1. #1
    Join Date
    Aug 2006

    Excel loses "Automatic calculation" option

    Normally if I am opening any Excel file and enter some data then I notice that the option to recalculate all formulas automatically clears out. Where I am going actually is Excel Options >> Formulas >> Calculation Options >> Workbook Calculation >> Automatic. I am using windows xp with service pack 3 and having Excel 2007 with SP1 MSO. Any ideas?

  2. #2
    Join Date
    Jan 2006
    Excel recalculation settings are not stored as application level settings but are stored in workbooks and this setting is taken from the First workbook it opens. I guess that you are not using a Personal.xls file, so the first file you open might be varying from Excel session to Excel session. If you open this particular workbook first, then Excel takes its recalculation setting from this workbook and it was saved with recalculation set to manual.

  3. #3
    Join Date
    Dec 2008

    Re: Excel loses "Automatic calculation" option

    Here's the Microsoft page that explains how Excel operates with respect to Manual and Automatic Calculation.

    Hope this helps.

Similar Threads

  1. Replies: 3
    Last Post: 04-03-2012, 01:53 AM
  2. Replies: 6
    Last Post: 18-05-2010, 01:27 AM
  3. Replies: 7
    Last Post: 27-01-2010, 01:11 AM
  4. Excel 2003 calculation automatic loss option
    By CitricAcid in forum Software Development
    Replies: 4
    Last Post: 08-04-2009, 11:09 AM
  5. Replies: 2
    Last Post: 17-01-2007, 09:47 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts