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

Hi Snow, I managed to create an example that can easily trigger the problem I'm having:

if you create 2 columns, 1 containing the name of the current sheet in each row and an incremental from 1 to a limit set in D4 (I entered 3000 as the limit) and if you create a 3rd column that contains in its first row the formula below (which calculates the factorial of each number modulo 170 in column 2 and then a simplified calculation of the inverse factorial) then you can reproduce the problem: once you hit enter in D5 which triggers the calculation of the cells, if you click in the sheet without waiting for the calculation to finish then you should get the same message as me. But if you wait for the calculation to finish you don't get this message. The annoying thing is that once I get this message, I have to quit Excel afterwards because it won't be able to calculate any more cells.

=LET(F;LAMBDA(G;N;N*SI(N>1;G(G;N-1);1));

      H;LAMBDA(G;N;I;SI((N/I)>1;G(G;N/I;I+1);N)); 

      BYROW(B5:DECALER(B5;D4-1;0); 

                      LAMBDA(R; 

                                        H(H;SIERREUR(F(F;INDIRECT(R&"!"&ADRESSE(DECALER(R;0;1)+4;3))); 

                                                            F(F;MOD(INDIRECT(R&"!"&ADRESSE(DECALER(R;0;1)+4;3));170)));1) 

            ) 

          ) 

)

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.

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.

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

Another discovery, I just learned there was another update released today February 11 2025. The timing of these last two updates and this error appearing twice immediately following each is suspect.

https://learn.microsoft.com/en-us/officeupdates/update-history-microsoft365-apps-by-date