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.

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, 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 Aaron, please do keep me posted as to the progress.

To assist anyone else in this situation: The above error did seem to reslove itself after a full network reboot.

• However, it does seem that the lambda functions (Since the January 31, 2025 update) were the cause of this resource shortage in the initial workbook. Note, these same functions were in use without issue for three years before January 31, 2025.

I went through my original spreadsheet and removed all lambda functions and replaced with more traditional computation options. Fortunately, the lambdas were more for elegance rather than need.

After removing them all - so far so good. (but it is early). I hope this doesn't appear agian and that this assists you.

Thank you for it. I will raise this bug to relevant team.

You may give feedback directly in Excel Application.

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

Click the Helpmenu and choose Give Feedback.

In the dialog box that opens, select the feedback you want to give.

Or create a support ticket to Microsoft using admin acount.

Please contact your admin/IT department create a support ticket via Microsoft 365 Admin Center> Support> New service request. Support team there will have the correct channel and resources to help you investigate more and find what exactly the reason has caused this situation.  Get support - Microsoft 365 admin | Microsoft LearnAbout how to find the admin in your organization, you can refer to How do I find my Office 365 admin