Updating my office
I can only assume that somehow the file had become corrupted.
I also have had this problem with a very large spreadsheet that just stopped updating itself over the weekend, but having checked the above solutions, setting were already set to automatic, and sheet is too big to rebuild, so I was at a loss.
Would you like to answer one of these unanswered questions instead?
My Office is an application to access and use all your Office 365 subscription benefits from one spot.
All Excel functions have one or more required arguments.
I am having to click on the formula bar, then I have to click enter for the formula cell to do its thing. I had a case of this just now on Excel 2010: a particular spreadsheet that would not auto-recalculate.
I changed the setting as indicated above; but the auto-recalculate still did not work, and upon rechecking the "Calculation" option, found it had reset itself back to "Manual" all by itself.
After opening the app I am unable to close the app and I have to restart the pc.
The main issue is after opening the app the app become totally unresponsive even we cannot click a single button.
Search for updating my office:
Somehow PI's Calculate method was no longer running during the normal workbook recalculate.