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.
makapu wrote: ``looks like the Bug for Excel 2016 version 2210 (Build 15726.20174).
So revert to Version 2209 (Build 15629.20208)``
nic-fleetwood wrote (Dec 3): ``Reverting Excel absolutely worked. [....] FYI, my build was a later build than the one mentioned before reversion``
This is good to know.
According to the cited update history, version ``2209 (Build 15629.20208)`` was released on 11 Oct 2022.
Any idea if this also affects Office 365 Excel on or about the same date? Excel 2019? Mac versions?
We have seen this complaint often in other forums, and not just for Excel 2016, IIRC We waste a lot of time trying to suss out details about the workbook, like excessive whole-column references in SUMPRODUCT formulas, etc.
makapu's response is a keeper.
This problem may occur in the updated version of Excel. In this case, I suggest that you can click feedback in the Excel application to directly report this problem to the relevant Excel teams, which can quickly make the comments attract the attention of developers.
You can open Excel and click File>Feedback>click I have a suggestion and write this query to feedback it to the Excel team.
https://support.microsoft.com/en-us/office/how-do-i-give-feedback-on-microsoft-365-2b102d44-b43f-4dd2-9ff4-23cf144cfb11
- Thank you makapu! I followed these steps and this seems to have fixed the issue for me. I was using the latest version 2302(Build 16130.20332) and as soon as I reverted to 2209 (Build 15629.20208) the problem immediately went away. I left microsoft a complaint via feedback
I am running Version 2211 Build 16.0.15831.20098 and have the same issue.makapu
It's not with every file however.
I am running Version 2211 Build 16.0.15831.20208, did you find any solutions?
