Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Sep 2001
    Posts
    211
    Thanks
    32
    Thanked 0 Times in 0 Posts
    I think I asked about this before but can't find the thread. Anyway, I have several Excel spreadsheets with simple formulas that have all of a sudden stopped updating when new data is entered. I have to physically go to each cell, hit F2 and Enter to get the data to update. These are spreadsheets that, up to now, have been behaving properly. I don't recall changing any settings and don't know what I would have done, even if they HAVE been changed. I have attached a sample file. Please advise. Thank you.
    Attached Files Attached Files

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    What isn't updating. Seems to work for me.
    Andrew

  3. #3
    3 Star Lounger
    Join Date
    Sep 2001
    Posts
    211
    Thanks
    32
    Thanked 0 Times in 0 Posts
    Hmmm, you're right. I went back and tried it again and now it's working. Don't know why it's temperamental. Guess I can't fix what isn't broke. Will just have accept I have to watch to be sure it's behaving properly. Thanks anyway!

  4. #4
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Just my 2 cents:

    Every once in awhile, this happens to me. No rhyme, no reason.

    When it happens, I go to:
    Tools/Options/Calculation tab.

    Somehow, the "Manual" radio button is checked.

    All I do is change it to Automatic, and life is back to normal.

    Don't know why it happens, but that's how I fix it. Stuff like that drives me crazy !!

    Michael

  5. #5
    Star Lounger
    Join Date
    Feb 2009
    Location
    Kings Park, Victoria, Australia
    Posts
    90
    Thanks
    15
    Thanked 5 Times in 5 Posts
    This has happened to me on several occasions, specially after using a particular worksheet when I switch calculation to Manual then back to automatic for subsequent worksheets. I think excel simply forgets that automatic calculation was switched back on. Very annoying behaviour.
    Maria
    Simmo7
    Victoria, Australia

  6. #6
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Excel uses the calculation setting of the first workbook opened.
    If the first workbook you open has calculation set to manual, that setting will apply to all subsequent workbooks opened.
    '--
    Jim Cone
    Portland, Oregon USA
    Special Sort add-in info link

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    And a further note to Jim's comment, if the subsequent files are saved, they will be saved as manual calculation files, unless explicitly changed back...

    Steve

  8. #8
    3 Star Lounger
    Join Date
    Sep 2001
    Posts
    211
    Thanks
    32
    Thanked 0 Times in 0 Posts
    Thanks! I check a couple of my spreadsheets and they were set to automatic but I will check every one I open to be sure they are set that way.

Posting Permissions

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