Excel Error "Excel ran out of resources while attempting to calculate" upon calculation interruption

Hi Snow Lu - I have created a test file for the related error that I detailed below (See the thread following Aaron Solomon3's) reply. I would be happy to share that with you. Please let me know how to do so.

These "Excel ran out of resources" errors must be related to the recent update and I have isolated one trigger as follows.

In the very basic test spreadsheet (See image below). The error was being triggered for simply multiplying columns with more than 255 rows of data.
255 worked, anything above that, caused the error. Obviously this is miniscule. I was using this function with thousands of rows of data without issue for years.

Niko, yes I still have the issue. Same here, I didn't roll back, I am rather looking the next release. Btw Microsoft Excel Team did reply to me on the 14th, looks it was an automatic reply since all the answers were already in my initial request (when did it happen, which version, sample file triggering the problem..). Anyway I replied to each question immediately, and didn't get any feedback yet. I'll let you know when they get back to me.

Hi Nico, thank you for sharing this and allocating time to create a basic spreadsheet that triggers the issue. This is a really annoying bug and I confirm that I experience the same problem on all my spreadsheets that include complex calculations. This was not the case before 16.93 (or 16.93.1) with those same files. In other words I could interrupt calculation and restart it without having to completely exit and restart Excel. Hope this is fixed soon.

I believe I made some progress for anyone reading this.
In order to debug this problem further - I had stripped down all the formulas in workbook on the most computationally complex worksheets.
FYI: An easy way to do this is just to search and replace all "=" with an unusual string, I use "meow". I then add back formulas one by one until the error is triggered.

The problem appears to have triggered at Lambda functions. I use the ByRow function a number of times.

=IF($E25#="UN",0,IF(GO$21="OFF",1,BYROW(EW25#:EZ25#,LAMBDA(x,IF(ISERROR(PRODUCT(x)),0,PRODUCT(x))))))

E25# contains various text string codes. If the value is "UN" it just returns a 0
EW25# to EZ25# are small numbers between (0 and 1)
The function above, that worked great for years, seems now be triggering the insufficient resources state.

----------------------------------------- Yes that seems to be the trigger
I tested it by creating four spillable sequences as shown below (Columns FA, FB, FC, and FD) They are 650 rows long and the formula in FE triggers the issues.

****** This is clearly a Microsoft update error, a formula that worked for three years shouldn't be triggering this. Especially with something as basic as multipying integers in for only 650 rows.
![](https://learn-attachment.microsoft.com/api/attachments/cf4713b8-5035-4dd0-81eb-902a17cd2e38?platform=QnA

Hi Snow, thanks for your reply. Unfortunately I would need to take some time to remove sensitive information from my files.

That said, my concern is that this happens on many files, and I never (as far as I remember) had such an issue previously, I mean before that update to 16.93.1 or 16.93 (not sure which of the 2 updates introduced the issue). Previously if I interrupted a calculation it would simply stop calculating... I didn't need to completely exit Excel and restart it... never. Now, I almost systematically get this message "Excel ran out of resources while attempting to calculate..." and then I need to close all Excel workbooks and exit Excel if I interrupt a calculation. This is such a systematic issue that I assume this is probably happening with other users. Don't you got other users reporting that issue after those updates ?