Forum Discussion
Excel ran out of resources while attempting to calculate one or more formulas.
Hi,
This issue looks like the Bug for Excel 2016 version 2210 (Build 15726.20174).
So revert to Version 2209 (Build 15629.20208) and disable Office updates.1. Start an Office application (such as Excel), and then select File > Account. select Update Options > Disable Updates.
2. Type cmd on the start menu, right click on the Command Prompt, choose Run as Administrator
3. Copy/paste these two commands one at a time and press enter
cd %programfiles%\Common Files\Microsoft Shared\ClickToRun
officec2rclient.exe /update user updatetoversion=16.0.15629.20208FYI:
https://learn.microsoft.com/en-us/officeupdates/update-history-office-2019
https://support.microsoft.com/en-us/topic/how-to-revert-to-an-earlier-version-of-office-2bd5c457-a917-d57e-35a1-f709e3dda841--------------------------------------------------
*If you use MSI versions of Office, delete windows update program.
Hi,
This issue looks like the Bug for Excel 2016 version 2210 (Build 15726.20174).
So revert to Version 2209 (Build 15629.20208) and disable Office updates.
1. Start an Office application (such as Excel), and then select File > Account. select Update Options > Disable Updates.
2. Type cmd on the start menu, right click on the Command Prompt, choose Run as Administrator
3. Copy/paste these two commands one at a time and press enter
cd %programfiles%\Common Files\Microsoft Shared\ClickToRun
officec2rclient.exe /update user updatetoversion=16.0.15629.20208
FYI:
https://learn.microsoft.com/en-us/officeupdates/update-history-office-2019
https://support.microsoft.com/en-us/topic/how-to-revert-to-an-earlier-version-of-office-2bd5c457-a917-d57e-35a1-f709e3dda841
--------------------------------------------------
*If you use MSI versions of Office, delete windows update program.
This did not work for me (reverting to old version of Excel), but what did work was changing the number of processors to manual in Options > Advanced > Formulas. I have 20 processors and for some reason changing it to use only 19 fixed the error from popping up.
I actually continued to have this issue all yesterday - it worked for a while but then would sometimes pop up again. I would play around with restarting excel, changing the number of cores, and sometimes it would work again but then it got to a point where the sheets weren't calculating correctly so I looked more for a solution.
What worked for me what downloading and reinstalling 64 bit Office365 - I had seen this mentioned in another thread but I think I had 32 bit downloaded because when I went to uninstall/reinstall and selected 64 bit, it said I had to remove this other thing before it would let me (implying that I had 32 bit downloaded the whole time). Now that I have 64 bit it is working.