Excel formulas not updating

Topic

New Reply

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.

Reply | Quote

Replies

What isn’t updating. Seems to work for me.

Reply | Quote

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!

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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.

Reply | Quote