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.
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.
Hi,
I had this issue in the following conditions: I created a new sheet to test a formula. The formula referred accidentally to the whole cells of another sheet. Then the message popped up. By correcting the formula, the message didn't disappear, even by removing the formula it didn't fix it. Applying your suggestions here and in other places was also unsuccessful.
Then I deleted the sheet containing at the origin the problematic formula (formula that was no more there because meanwhile deleted), and suddenly the error message disappeared. So you can try to find out in which sheet - at a given point in time - you had the misfortune to pronounce the unforgivable formula that Excel will never forget even if you remove it for its cells, then eventually copy the whole sheet somewhere else, delete it and recreate it from scratch...
Good Luck !
makapuShould anyone be chasing a solution not requiring uninstallation of Excel updates, the following worked for me:
Click File - Info - Check for Issues - Check Compatibility. Then the this error information was displayed:
I clicked Find which took me straight to a bogus formula which was =+D54:CBC351424 in case anyone is interested. I deleted that cell's contents and was immediately able to work in the spreadsheet once more.
Hope this helps anyone searching for a solution as I was this morning.
- That is what my problem was. Thankful for this posting so I could get on with my work!
Thanks for this!
I followed this advise a while ago. It solved the problem. However, I am trying to use the IMAGE function and it's not showing up as an option for me. My guess is this is because I reverted back to that older version of Excel. I believe I would like to undo this change you suggested. What should I enter in the cmd?
Apologies: on inspection I find the CMD commands you advised have indeed reverted Excel to build 15629.20208 BUT, sadly, the problem continues. What on earth am I doing wrong????
with regards
I have the same problem, tried like 5 different builds with no results. What interesting though, on my working computer at office file opens and works well. It has Windows 10, at home I use Windows 11 and excel just refuses to work with my worksheet... It is terrible, and hurts my business. Bill, do something
I am having this same issue all of a sudden. Everything I type into a file or even if I try to expand a column, I will get this 'ran out of resources' alert. The action happens and I'm able to continue, but the alert prevents any two consecutive actions on my part without having to clear the alert.
I'm running on MacBook Pro M1 and using Microsoft Excel for Mac version 16.70 (23021201).
Would appreciate any guidance to help fix this. Additional info (not sure if related) -- yesterday I was running several workbooks with various vlookups and pivot tables. At some point I started to get the dreaded spinning circle after every action, but it would eventually resolve. I have shut down the app, shut down my laptop and restarted with no other apps running. I've check Activity Monitor and it's not consuming much. Now it is responding quickly, but just giving that Alert message after every entry or movement.
- this worked
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.
