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

Anonymous

I am using Excel, latest version for Mac, 16.93.1 (25011917), and following a recent update either to 16.93 or 16.93.1 I have systematically an error message if I interrupt a calculation : "Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated." after this error I must always quit excel and restart which is very annoying. Anyone having the same issue ?

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

63 answers

Anonymous

2025-02-19T20:29:15+00:00

Aaron are you finding the issue persisting? We are seeing it pop up in less complex spreadsheets as well: ones without Lambda functions and those that are clearly not a complicated enough to cause a resource shortage. These also did not have any issues for years prior January 31 2025.

We did not roll back to the older version of Office yet as we seem to be operational but very annoyed.
Was this answer helpful?

0 comments No comments
Anonymous

2025-02-14T13:58:21+00:00

Thanks Snow, I have just sent the problem description via the Excel feedback channel you recommended.
Was this answer helpful?

0 comments No comments
Anonymous

2025-02-14T13:56:37+00:00

sure will do
Was this answer helpful?

0 comments No comments
Anonymous

2025-02-13T18:32:18+00:00
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)&gt;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) 

            ) 

          ) 
```
)
Was this answer helpful?

0 comments No comments
Anonymous

2025-02-07T17:37:03+00:00

This can be a common problem, especially with large or complex spreadsheets. Simplify complex formulas or break them down into smaller parts. This can help reduce the amount of resources needed for calculations.

Could you share a test file? Then I can help you optimize the formulas on that file.

For sharing file, you may upload it to OneDrive or any other cloud drive and then post the link here. *Please make sure you have removed any sensitive or private information in the sample file before uploading.
Was this answer helpful?

0 comments No comments