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-03-06T13:44:57+00:00

    Hi Aaron

    Could you please share the repro workbook?

    I'm currently engaged with MS Customer Support on this issue. They are refusing to acknowledge this thread, instead asking me to do invasive and time-consuming diagnostics as a pre-requisite for escalation to the relevant teams. I'm hoping that this repo workbook will help shortcut the debate.

    Thanks and Regards

    David Crouch

    Was this answer helpful?

    0 comments
  2. Jim G 134.1K Reputation points MVP
    2025-03-07T15:58:24+00:00

    Was this answer helpful?

    0 comments
  3. Anonymous
    2025-03-07T17:44:33+00:00

    Was this answer helpful?

    0 comments
  4. 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
  5. 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