Forum Discussion

LukeFM's avatar
LukeFM
Copper Contributor
Nov 05, 2022
Solved

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's avatar
    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's avatar
HansVogelaar
MVP
Nov 05, 2022

LukeFM 

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

JodiG975's avatar
JodiG975
Copper Contributor
Oct 12, 2024

HansVogelaar 

 

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

 

 

 

 

 

 

 

 

Resources