Forum Discussion
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 m...
This 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.
