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: Newest
Most helpful Newest Oldest
  1. Anonymous
    2025-05-26T05:21:04+00:00

    An update from our end - the entire MS team who has handling our support request appears to have been laid off.

    All of the people we were emailing now are unknown recipients/addresses.
    It seems like our support request has been "lost", despite having an issue tracking # etc

    This situation has forced us to abandon using spill ranges and lambda functions. Instead we are now looking to move functionality into python-based add-ins, use Excel purely for display/UI.
    I don't want to go down that path, I liked keeping logic sheet-based and transparent. But this bug is a show-stopper, we don't have the time to randomly test new Office releases. Overall quite alarmed at how MS manages regressions and incidents, at least based on this experience.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Jim G 134.1K Reputation points MVP
    2025-05-03T13:39:12+00:00

    Unfortunately, the time schedule is that fixes are released to the beta channel first. Those releases are weekly. If it appears the problem is solved in the beta channel and no new problems were introduced by the fix, then the fix becomes incorporated to the current channel release, which is monthly. From this schedule, it would appear that it could take up to 8 weeks after a successful fix is made before it reaches current channel. Microsoft relies on feedback from users of beta channel builds to determine whether the fix is working.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2025-05-03T13:14:24+00:00

    Hi Jim, I followed your advice and tried each new version since I reported the issue, including the betas, and the issue is still there. I had to revert to Excel 16.92 because this is the latest version with which I don’t have the issue. I deactivated automatic updates for Microsoft Office, so I don’t get the latest updates or patches, only manually trying them for test purposes. I don’t know when to reactivate the automatic updates. I’d really appreciate an ETA for a fix, since the issue has been reported for 3 months...

    versions tried :

    16.93 16.93.116.93.216.9416.94.116.94.216.9516.95.1 beta16.9616.97 beta16.98 beta

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Jim G 134.1K Reputation points MVP
    2025-04-07T15:48:33+00:00

    If you want to try solutions that are being tested, consider joining the beta program:

    Welcome to the Office Insider for Mac community!

    Was this answer helpful?

    0 comments
  5. Anonymous
    2025-04-07T07:58:07+00:00

    Thanks Jim, I did report the issue early February to Microsoft with a sample file for them to reproduce it, but haven’t heard of a resolution so far.

    Was this answer helpful?

    0 comments