Forum Discussion
Excel ran out of resources while attempting to calculate one or more formulas.
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:
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.
@This has happened to me twice now.
I'm just putting the answer here for anyone searching for answers in the future.
There will be an error in one of the cells that are in the data range, it can take a while to find it as it's not always very visible.
Our error was that someone inputting must have knocked some keys and in one of the cells they had accidentally entered '=+AX:VW', it came up as 0 which was why it took me a bit to find it.
Usually I just highlight all the cells in the range and just press delete but in this case I needed the data so it took me a bit to fine it.
Going to the toolbar and clicking on 'Formulas' and the 'Error Checking' function is helpful as well.