Forum Discussion
LukeFM
Nov 05, 2022Copper Contributor
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...
- Nov 15, 2022
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:
Update history for Office 2016 C2R and Office 2019
How to revert to an earlier version of Office--------------------------------------------------
*If you use MSI versions of Office, delete windows update program.
HansVogelaar
Nov 05, 2022MVP
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.)
- MaryDMB11705May 24, 2023Copper Contributor
HansVogelaar Thank you very much getting it out of safe mode worked!
- LukeFMNov 05, 2022Copper Contributor
HansVogelaar thanks for the response, really appreciate it!
I believe all Add-ins are already disabled - all the boxes are unticked when I go to manage on the Add-ins screen.
Safe mode didn't work either 😞
Any other ideas...?
- HansVogelaarNov 05, 2022MVP
In Windows Explorer / File Explorer, type the following in the address bar, then press Enter:
%appdata%\Microsoft\Excel
You should see a file named Excel15.xlb
Make sure that Excel is not active, and rename this file to Excel15.old
Then start Excel to see if the problem is gone.
If it remains, you can quit Excel and rename the file back to Excel15.xlb
- JodiG975Oct 12, 2024Copper Contributor
Thanks for your help.
I tried the suggestions:
1- starting in safe mode by holding the CTRL key (didn't seem to work)
2 - renaming to Excel15.old from Excel.xlb (in C:\Users\Jodi Gordon\AppData\Roaming\Microsoft\Excel) - before opening excel (which worked for a while then the error started again)
3 - switched to manual data calculations instead of auto - which seemed to fix the error, until I ran the data calculations again
4 - then switched back to Safe mode after trying 1-3 (and also paused OneDrive, so it wasn't synching), and these all seemed to help a bit (particularly turning off auto calculations - being the most effective).What a frustrating error message!
Using V2409 Build 18025.20140 Click to run... yeah right