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.
LukeFM In my case the currency formula caused the problem, I tried to change the currency to another currency instead of my country's currency, and then the problem was gone. My formula is:
STOCKHISTORY(AG1,$AE$1,$AE$2,1,1,0,2)
I used a cell AG1 to reference my currency. Hope this helps. The problem exists even though there is no precedent or dependent cell. I think maybe I changed my Windows 11 language for non-Unicode programs setting, it was using another country setting, I changed it to my country setting yesterday. I changed it back to the original one but still got the problem.