Excel ran out of resources while attempting to calculate one or more formulas.

Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated. Hi Everyone, I'm getting the above error message when openin...

excel

Formulas and Functions

office 365

makapu
Nov 15, 2022
LukeFM
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.

HansVogelaar

MVP

Nov 05, 2022

LukeFM

Since this happens in any workbook: do you have any add-ins installed? If so, try disabling all of them in File > Options > Add-ins. If the problem goes away, one of the add-ins must be the culprit. By enabling them one by one and testing after each step you should be able to find the culprit.

Something else to try:

Make sure Excel is not active.

Hold down the left Ctrl key while you start Excel. You should see a dialog asking whether you want to start Excel in Safe Mode. Answer Yes.

Does the problem persist?

(All your personal settings will be missing, but don't worry. They'll be back the next time you start Excel the normal way.)