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: Most helpful
Most helpful Newest Oldest
  1. Jim G 134.1K Reputation points MVP
    2025-03-22T14:57:03+00:00

    Microsoft does not provide predictions about when bugs will be fixed.

    If you want to get the test builds, you might consider joining the beta program:
    Welcome to the Office Insider for Mac community!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2025-03-22T13:36:20+00:00

    I just reverted to Excel 16.92 (for Mac) and don't have the issue anymore. But I also deactivated the automatic update for office thus not getting the updates nor patches. Before doing that I waited for each update hoping it would fix the issue but none of them did : 16.93.1, 16.93.2, 16.94, 16.94.1, 16.94.2, 16.95, 16.95.1. It would at least be helpful to get an ETA so that I can reactivate the updates...

    Was this answer helpful?

    0 comments
  3. Anonymous
    2025-03-22T12:06:34+00:00

    I solved my problem in this way ...instead of using a stockhistory call in lots of individual cells, I replaced this by using only one stockhistory call using 2 arrays ..one for the tickers I'm interested in and one for the dates for which I need the stock value

    Was this answer helpful?

    0 comments
  4. Anonymous
    2025-03-22T11:17:22+00:00

    I am also experiencing this problem.

    I have an excel workbook with several lambdas that process data obtained from multiple stockhistory requests

    If I pull too much stockhistory data then I get successive "Excel ran out of resources ..." popups

    If I remove the lambdas then I don't get the errors

    The problem is intermittent, a reboot clears it for a while but it always returns eventually.

    I haven't tried the workbook on older versions of excel.

    Microsoft® Excel® for Microsoft 365 MSO (Version 2503 Build 16.0.18623.20076) 64-bit

    Win11 Home 23H2 build 26100.3613

    Ryzen 9 7900 (12 cores) with 64 GB of memory

    Was this answer helpful?

    0 comments
  5. Jim G 134.1K Reputation points MVP
    2025-03-16T00:24:16+00:00

    Me too, but typically Microsoft does not reply directly to requests for fixes. You find out by waiting for things to work right in a future update.

    Was this answer helpful?

    0 comments