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-13T01:48:15+00:00

    Hi

    This forum is not Microsoft Support. It is populated by other users who voluntarily help each other.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2025-03-13T00:42:42+00:00

    Hi, can you please share that workbook? Dropbox?

    Was this answer helpful?

    0 comments
  3. Anonymous
    2025-03-13T00:38:37+00:00

    Thank you, I have been given instructions on how to upload, that isn't the issue.

    Our sheets are large and contain confidential information. They also depend on 3rd party add-ins that we can't re-distribute. We don't have time to make a frozen values-only replica, as we'd need to make stubs for the 3rd party add-in function calls - there are alot.

    I don't understand why Microsoft Customer Support can't at least acknowledge what is being reported here, it is classic customer bikeshedding.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2025-03-13T00:30:04+00:00

    Thanks for your kind efforts.

    I could access the drop box file, however the sheet doesn't work for me - cell D5 onwards becomes #REF.  I'm sorry to say that I can not grok what this sheet is trying to do - is it a Fibonacci sequence?

    To clarify, I am running on Windows 11 and Microsoft® Excel® for Microsoft 365 MSO (Version 2412 Build 16.0.18324.20092) 64-bit. This is the Excel build that works OK with our sheets.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2025-03-13T00:02:23+00:00

    Having the same issue in the past couple of days. The issue was in STDEV.P formula. I was referencing the whole column, and then reduced just to the rows I needed. Excel doesn't blow up anymore.

    The sheet includes other somewhat complicated formulas, so maybe having fixed this issue it will turn up elsewhere. But at least now i can do a recalc.

    Was this answer helpful?

    0 comments