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

Anonymous
2025-02-06T22:04:26+00:00

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 ?

Microsoft 365 and Office | Excel | For business | MacOS

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

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2025-02-24T07:14:51+00:00

    Hi David, Microsoft Excel Team did reply to me confirming that they could reproduce the problem with the sample i provided them and that a bug was posted to the Mac Excel engineering team. So I am expecting to get a fix, but not sure how they manage excel bugs across platforms so just in case please feel free to use my simple example :

    With a new workbook, create 2 columns like the screenshot attached : 1 starting in b5 containing the name of the current sheet in each row and one starting in c5 containing an incremental from 1 to a limit set in D4 (I entered 3000 as the limit) and create a 3rd column starting in d5 that contains in its first row the formula below (which calculates with lambda functions 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 you should get the same error message. 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, you have to quit Excel afterwards because it won't be able to calculate any more cells.

    I can attach the workbook if you want.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2025-02-24T07:57:12+00:00

    Thank you Aaron for your prompt and detailed reply. I will share this with the MS support contact we have in our case.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Jim G 134.1K Reputation points MVP
    2025-02-24T15:10:05+00:00

    If you are interested in testing potential fixed versions, please consider joining the beta channel:

    Welcome to the Office Insider for Mac community!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2025-02-25T06:35:56+00:00

    Hello Jim

    Thanks for the MS insider reply. Are you able to confirm if MS acknowledges this issue for Windows as well?

    Thanks and Regards

    David Crouch

    Was this answer helpful?

    0 comments
  5. Jim G 134.1K Reputation points MVP
    2025-02-26T16:52:17+00:00

    Hi again,

    MVPs are not allowed to speak for Microsoft Corporation nor share what we know about things like this. Aaron is not under the same rules and is free to share what Microsoft said.

    If you join the beta program you'll get weekly updates and your feedback submissions via the Help menu will bypass Microsoft general support and go directly to the Excel developer team.

    Was this answer helpful?

    0 comments