Forum Discussion

SeaGreen's avatar
SeaGreen
Copper Contributor
Nov 11, 2022
Solved

Excel ran out of resources

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 opening or doing any sort of calculation on any file. It seems others are having the same issue recently. I've tried all of the suggested fixes but nothing seems to work. It started upon opening the worksheet a few days ago without making any changes. Could it have be caused by an update?

 

Thanks,

 

Cam

excel

11 Replies

Sort By
  • makapu's avatar
    makapu
    Brass Contributor
    Nov 15, 2022

    SeaGreen 

    Hi, SeaGreen.
    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.

     

    • ruthschinstock's avatar
      ruthschinstock
      Copper Contributor
      Mar 23, 2023

      makapu 

      If I take this route to revert back to the older version will it wipe my hard drive? Should I backup all my files before trying this?

      • CRMcD1984's avatar
        CRMcD1984
        Copper Contributor
        Apr 14, 2023

        Hi,

         

        I am trying to enable this fix and am getting the following Command Line repsonse. I fear I am doing something trivially incorrect.... can some one send a gentle assist?

         

         

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Nov 11, 2022
    This error may have something to do with the way the formulas are written. Are you able to share some of your formulas?
    • SeaGreen's avatar
      SeaGreen
      Copper Contributor
      Nov 11, 2022
      The same formulas have been in use for roughly a year. No changes or additions were made when the error started. Do you think it could still be a formula causing the issue? Just not sure where to start, there are many.
      • Patrick2788's avatar
        Patrick2788
        Silver Contributor
        Nov 11, 2022

        SeaGreen 

        Yes. I've seen this error many times. Often the cause of it is using referencing in formulas that points to entire columns.

        For example:
        =VLOOKUP(A2,Sheet2!A:Z,10,0)

         

        It could also be the use of volatile functions (INDIRECT, OFFSET, etc.), excessive formatting, and/or a very large 'usedrange' (When you press Ctrl+End on a sheet, where does it go to?).

Resources