Forum Discussion
CKnapp8524
Jun 25, 2024Copper Contributor
Error Code "Excel ran our of resources while attempting to calculate one or more formulas"
Hi there!
I couldn't find an updated response to this issue so figured I would repost for some help. I am getting the error code "Excel ran our of resources while attempting to calculate one or more formulas" every time I try to enter anything in a cell...
Using Microsoft 365, Ver 2405, 16.0.176.28.20006
4 Replies
Sort By
- RayF605Copper ContributorThis error started to come up recently on my subscription to Msft 365. The file with STOCKHISTORY function, and I put in VBA to create function "COUNTcellsbyfontcolor". Decided to Copy/Paste/Value all formulas and wipe file clean of formulas. Then I recreated the formulas. That solved the problem. BUT then the COUNTcellsbyfontcolor didn't work, and returned an error. I had saved the file as XLSB, and had to resave as XLSM, and this made the function work again. I believe Excel just "CHOKED" for whatever reason, and formulas got "corrupted", and I had to wipe the slate clean, and redo. This solved all errors.
- wwpmoaCopper ContributorThis is not exhaustive solution. I am intermediate user. You might check for linked workbooks under the Data menu at Queries and Connections. You might explore the Formula Auditing options under Formula menu. You might look for circular references. You might review the ranges for Defined Names under the Formula menu. You might copy and paste just the area you are working with into a brand new workbook and worksheet and try again, in case Excel is trying to apply a formula to too many rows/columns. You might clear your recycle bin. You might check if you have the latest updates for your Excel program. You might limit the number of programs you run at the same time as Excel.
90% of cases in modern Excel, at least what I've seen, if people mistakenly write something like =16:20015 , or in bit more complex cases the same with more complex references. Legacy Excel didn't care about such mistakes since didn't work with dynamic arrays.
Here first thing to do is to make Workbook Analysis with Inquire and check suspicious array formulae.
Rest 10% - yes, lack of resources for heavy loaded by formulae workbook.
It's better to discuss on concrete file. Please check https://techcommunity.microsoft.com/t5/excel/getting-this-msg-quot-excel-ran-out-of-resources-while/m-p/2003279#M84061 if some of cases are similar to your one.