Nov 11 2022 08:49 AM
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 or doing any sort of calculation on any file. It seems others are having the same issue recently. I've tried all of the suggested fixes but nothing seems to work. It started upon opening the worksheet a few days ago without making any changes. Could it have be caused by an update?
Thanks,
Cam
Nov 11 2022 08:57 AM
Nov 11 2022 09:01 AM
Nov 11 2022 09:09 AM
@LuisElCaminanteI get a note "You do not have permission to upload images"
Nov 11 2022 09:14 AM
Nov 11 2022 09:20 AM - edited Nov 11 2022 09:21 AM
Yes. I've seen this error many times. Often the cause of it is using referencing in formulas that points to entire columns.
For example:
=VLOOKUP(A2,Sheet2!A:Z,10,0)
It could also be the use of volatile functions (INDIRECT, OFFSET, etc.), excessive formatting, and/or a very large 'usedrange' (When you press Ctrl+End on a sheet, where does it go to?).
Nov 11 2022 09:24 AM
Ctrl+End does take me well down each sheet (i.e. row 500 - 1000)
Nov 11 2022 09:32 AM
Nov 14 2022 07:57 PM
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:
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.
Mar 23 2023 01:42 PM
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?
Apr 14 2023 09:04 AM
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?