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.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 03, 2023

hillbillyfairy 

Formula could be like =G152:RG141152:S152:QG152 as in one of previous post. I'd check all cells which start from =

Ctrl+F is the simplest way.

hillbillyfairy's avatar
hillbillyfairy
Copper Contributor
Aug 03, 2023

SergeiBaklan I searched for formulas using the "go to special..." reports NO FORMULAS. For some reason today it seems fine. Which makes no sense at all, because after doing a reboot yesterday and only opening Excel+file it acted up. Now I'm sitting here wondering what's going on, and when it's going to pop up again.

Resources