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.
Thanks again for your help, if you have any other suggestions then I'm all ears!
I am really sorry, but I'm out of ideas...
- No worries. Appreciate your efforts!
I think I have found something of a workaround - if I turn calculations to manual, I can at least work without the dialog box popping up every time I hit enter / leave a cell. Would I be correct in saying that I can do this, then occasionally turn it back on to automatic, and when I hit enter on a formula again the whole workbook will update as if nothing was wrong?
Btw I've already error-checked all the formulae within the workbook and there are no circular references.You can try that, and see if the error message pops up when you enable calculations.