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 o...
excel
  • SeaGreen's avatar
    SeaGreen
    Nov 15, 2022

    makapuThank you! This solved my issue.

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?

     

     

Resources