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...

excel

Formulas and Functions

office 365

makapu
Nov 15, 2022
LukeFM
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.20208
FYI:
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.

makapu

Brass Contributor

Dec 04, 2022

This problem may occur in the updated version of Excel. In this case, I suggest that you can click feedback in the Excel application to directly report this problem to the relevant Excel teams, which can quickly make the comments attract the attention of developers.

You can open Excel and click File>Feedback>click I have a suggestion and write this query to feedback it to the Excel team.

How do I give feedback on Microsoft 365? - Microsoft Support