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.
Pat_Schultz
Feb 04, 2023Copper Contributor
I contacted Microsoft as I had just purchased the product. Some how my copy became corrupted. Fortunately, I had an older copy of the sheet I was using so I didn't lose the data. They tried to fix it but were not successful. They did get the overall problem of that error message to go away in my other sheets and now it is working fine. Sorry, not a tech person and I don't know what all they had to do to fix it or what caused it.
JoeUser2004
Feb 04, 2023Bronze Contributor
Pat_Schultzwrote: ``I contacted Microsoft [....] Some how my copy became corrupted``
Of course MSFT would say that. It is much better for them to claim that your files are bad than to admit to their errors in creating updates.
I am more inclined to believe the update is bad; perhaps it caused the file corruption. That seems more likely, considering the plethora of recurring complaints about Office 365 updates.
Just a biased opinion, not based on any facts. But my suspicion of the quality of frequent (poorly-tested) updates is the reason why I refuse to "upgrade" to a subscription service.