Excel Error "Excel ran out of resources while attempting to calculate" upon calculation interruption

Sorry I can't give any such info because we can't get any response from MS.

Our support experience has been disappointing - we provided all logs/repro/explanation, but never received any solid acknowledgement. Now the channel has gone dead, it seems.

Seemingly the issue is related to the speed of the called lambda function and/or the number of lambda functions.

I'd be surprised and disappointed if they deprecate LAMBDA, it is very useful, especially when combined with spill ranges.

Hi David,

Thanks for this update.

Do you have any information on Microsoft's plans for lambda functions? Do you think this part of Excel will be abandoned? Like you I do really appreciate keeping logic sheet based and wouldn’t want to be forced to use other solutions like Python or even cloud-based data processing.

Unfortunately, the time schedule is that fixes are released to the beta channel first. Those releases are weekly. If it appears the problem is solved in the beta channel and no new problems were introduced by the fix, then the fix becomes incorporated to the current channel release, which is monthly. From this schedule, it would appear that it could take up to 8 weeks after a successful fix is made before it reaches current channel. Microsoft relies on feedback from users of beta channel builds to determine whether the fix is working.

If you want to try solutions that are being tested, consider joining the beta program:

Welcome to the Office Insider for Mac community!

Thanks Jim, I did report the issue early February to Microsoft with a sample file for them to reproduce it, but haven’t heard of a resolution so far.