Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Las Vegas, Nevada, USA
    Posts
    342
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Automatic Calculation (XP/2003)

    A recent condition has popped up on my computer using Excel XP.
    When I click on a new cell the previous information does not automatically re-calculate.
    It will only change when I save the file.

    I checked "Tools", "Options", "Calculation" tab and found the Calculation manual radio button selected.
    I changed it to automatic radio button, then OK.
    It works as expected, however the next day when I fire up the computer and open Excel it has reverted back to manual.

    This has not occurred previously, so what has changed?
    Any suggestions on how to keep it on Automatic?
    Richard Spring

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

    Re: Automatic Calculation (XP/2003)

    Do you have a workbook that loads automatically? If so, make sure that it is set to Automatic calculation, otherwise Excel will be set to Manual calculation each time - see MSKB article Description of how Excel determines the current mode of calculation.

    You can try Jan Karel Pieterse's <!post=Systematic Approach to Behavioral Problems in XL,290455>Systematic Approach to Behavioral Problems in XL<!/post>.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Las Vegas, Nevada, USA
    Posts
    342
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Automatic Calculation (XP/2003)

    Hans: I do not have a specific workbook that open just the default blank one.
    I will go through the suggested reading you offered to see if I can resolve it.

    I have an idea it might be related to my Logitech wireless keyboard and mouse.
    It has caused a problem or two in the past and I had to reset it.
    The only problem is it has been many months ago and I will have to re-learn how to do it.
    Will advise what I find out.

    Thanks again for the fast response.
    Richard Spring

Posting Permissions

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