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.
I am having the same issue (I am using Excel 365, updated this month, on a new computer but the issue seems to have carried over from the last laptop I was using...), but the command prompt second line isn't working for me/doesn't seem to be fixing anything... please help!
I am in the same boat. Have a new laptop for a month from BestBuy, and got the 365 subscription. I started using Excel and am getting the "out of resources" message. Sooo frustrating!!!! From the older posts this seems like an evergreen problem dating back to 2022 (and perhaps before). I can't believe MSFT can be so shoddy to put out updates that doesn't fix this. It is NOT THE RESPONSIBILITY of users to start scrambling for a solution, when the PROBLEM is the Software Manufacture MICROSOFT. I wonder if there is a MSFT Support Tech that reads this, and replies back with a fix.