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.
Thanks for your feedback, Jim. I hope Microsoft can resolve this issue soon.
Thanks for your feedback. The sheet calculates the factorial and inverse factorial of N numbers, with N typically = 3000. To do this, I define a first function F that recursively calculates the factorial of a number, and a second function H that recursively calculates the inverse factorial of the result. H therefore calls F for each value, and BYCOL is used to parse the N Values. I am using Lambda functions to do this instead of FACT in order to replicate the issue I am having with my other excel sheets, in which I also use Lambda functions. I just tried again the Excel sheet I shared on the dropbox link and it still works (except for the very annoying issue reported in this thread). I am using Microsoft Excel for Mac version 16.95 (25030928) as part of Microsoft 365. I am not familiar with the Windows version, but it looks you are also using Excel version 16.x with Microsoft 365 so it should work.
Hi Aaron.
I am glad that I found this post as I was complaining about this particular issue with Excel for a short while now. I found that spreadsheets that used to function fine often gave this particular error. Closing Excel and re-opening seemed to "fix" it. But I agree with you, it used to work, so a recent update must have caused the issue. I look forward to Microsoft's resolution.
Thank you for escalating!
Hi David & Aaron
Thanks for the file to reproduce the problem. I am able to reproduce this error on both Mac and Windows Excel. The link to the file has been shared with the Microsoft Excel team so they can investigate.
-Jim
I appreciate you trying to help me, but I understand the modus operandi of this forum.
I've not suggested anywhere that this is MS Customer support, simply that I am engaging with them now. I do note that one of the contributors to this thread seems to be an MSFT employee (Snow Lu).
I just find it frustrating that MS support refuse to look at what has been raised here. Instead, they are asking me to do disruptive and laborious profiling/logging, purely as a pre-requisite to looking at what has been raised here.