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 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.