Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automatic Calculation Setting (Excel 2000 SR-1)

    Hello,

    I have recently run into a problem. Whenever I start Excel, the Calculation Setting is set to manual. I have tried changing it to Automatic, but whenever restart Excel, it is set back to Manual. Can someone please help change the default back to automatic?

    Thanks

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Automatic Calculation Setting (Excel 2000 SR-1

    Excel picks up it's calculation mode from the first workbook it opens, which in many cases is personal.xls

    If you have personal.xls try the following:
    Select Windows > Unhide and choose Personal.xls workbook
    Go to Tools > Options and set the calculation mode to automatic
    Save personal.xls & hide it (Windows > Hide)
    You will still be asked if you want to save personal.xls when you quit excel, choose Yes.

    If you do not have personal.xls, check your xlstart directory for any file that opens automatically and reset calculation mode and then save those files.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Automatic Calculation Setting (Excel 2000 SR-1)

    In addition to Tony's excellent advice, check out <!post=Systematic Approach to Behavioral Problems in XL,290455>Systematic Approach to Behavioral Problems in XL<!/post>.

Posting Permissions

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