Forum Discussion
Solved
Stumped with 'ran out of resources'
Hello all, I have searched this community as well as the internet, and tried all the suggestions to get rid of this issue but without success. Things tried: Reduced and simplified conditional for...
Hi,
We have the same issue here. Problem is with latest Office version (2501/2502). You need to downgrade to 2412 and everything will work again (https://www.accessforever.org/post/roll-back-to-previous-versions-of-office).
You can also just change channel (MonthlyEnterprise) and it will roll back to the 2412 version. Let's hope Microsoft will solve this issue.
Mickaël
Quite often such error due to mistakenly (misprint or manipulation with grid) formula like
Other samples in this Getting this msg "Excel ran out of resources while attempting to calculate one or more formulas." | Microsoft Community Hub and couple of other threads here.
You may try Inquiry (if available for your Excel) to check suspicious array formula