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-02-19T20:29:15+00:00

    Aaron are you finding the issue persisting? We are seeing it pop up in less complex spreadsheets as well: ones without Lambda functions and those that are clearly not a complicated enough to cause a resource shortage. These also did not have any issues for years prior January 31 2025.

    We did not roll back to the older version of Office yet as we seem to be operational but very annoyed.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2025-02-14T13:58:21+00:00

    Thanks Snow, I have just sent the problem description via the Excel feedback channel you recommended.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2025-02-14T13:56:37+00:00

    sure will do

    Was this answer helpful?

    0 comments
  4. Anonymous
    2025-02-14T02:54:54+00:00

    Thank you for it. I will raise this bug to relevant team.

    You may give feedback directly in Excel Application.

    How do I give feedback on Microsoft 365? - Microsoft Support

    Click the Helpmenu and choose Give Feedback.

    In the dialog box that opens, select the feedback you want to give.

    Image

    Or create a support ticket to Microsoft using admin acount.

    Please contact your admin/IT department create a support ticket via Microsoft 365 Admin Center> Support> New service request. Support team there will have the correct channel and resources to help you investigate more and find what exactly the reason has caused this situation.  Get support - Microsoft 365 admin | Microsoft LearnAbout how to find the admin in your organization, you can refer to How do I find my Office 365 admin

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2025-02-13T18:38:59+00:00

    Hi Aaron, please do keep me posted as to the progress.

    To assist anyone else in this situation: The above error did seem to reslove itself after a full network reboot.

    • However, it does seem that the lambda functions (Since the January 31, 2025 update) were the cause of this resource shortage in the initial workbook. Note, these same functions were in use without issue for three years before January 31, 2025.

    I went through my original spreadsheet and removed all lambda functions and replaced with more traditional computation options. Fortunately, the lambdas were more for elegance rather than need.

    After removing them all - so far so good. (but it is early). I hope this doesn't appear agian and that this assists you.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments