This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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 ?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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.
Posting these clues and behaviors in the forum is great, but PLEASE be sure to send those same comments to Microsoft by using the Menu Bar and choosing Help > Feedback > Report a problem. Microsoft does not monitor the forum, but the do read every problem report sent to them via this procedure.
It is also important to emphasize another faulty behavior of Excel: if you start a calculation that lasts at least a few seconds and interrupt it (by selecting a cell in the current sheet for example, or by pressing the Esc key), then Excel will display this message "... run of resources...", and will then remain in a broken state. This happens EVEN IF the calculation would have been performed correctly if it had not been interrupted, leaving Excel in a non-broken state.
Actually, what I found is that after setting NumDays = 20000, it would trigger the error.
Then I lowered to 50, and the message did not appear.
But then if I set to 500, the message would trigger again.
So definitely, it seems that once the resource threshold is exceeded, Excel is left in a broken state
As I said, Microsoft is aware of the problem and is seeking more example workbooks to test.
Generate a workbook that illustrates the problem. Send it to Microsoft using the Menu Bar and choosing Help > Feedback > Report a Problem.
We're experiencing the same issue for the past month, in a workbook that includes advanced LAMBDA formulas. We're currently on the Microsoft 365 Monthly Enterprise Channel.
Has anyone seen a resolution or workaround for this yet?