Commonly misspelled words will be corrected immediately, making your review process faster.Regardless of the version of Microsoft Office Suite that is installed on your computer, it's important to keep your suite up to date.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.Three attempts later and it was still adamant it wanted to be "Manual" and nothing else.Microsoft frequently issues updates that improve the functionality, performance, stability, and security of all their office tools, including MS Word.Here's how to keep your Microsoft Office Suite up to date.delete the predecessor and retype the same manually. Worst part is that I have to do it for all the subsequent tasks. To get started using the site, enter in your search terms in the Search box above or visit our FAQ for search tips.
I can only assume that somehow the file had become corrupted.
I opened this spreadsheet, checked that this was still working and autoupdating with current installation of MS Excel and any new automatic office updates (which it did work with), and then just reopened the original spreadsheet. I ran into an issue where some cells weren't calculating.
I checked all the normal things, like cell type, auto calculation, etc...
Somehow PI's Calculate method was no longer running during the normal workbook recalculate.
In Settings I had to change Automatic Update command to Full Calculate and then back again.