Forum Discussion
Excel ran out of resources while attempting to calculate one or more formulas.
Could you share one of such workbooks removing sensitive information?
Okay, so the other day when I asked this question, it was doing it on all of my workbooks like previously stated. But right now, it is only doing it on one workbook. However i have removed a lot of unnecessary data. I have checked for errors on all my sheets and removed or ignored them all.
I went to the highlight "credit tip" column pictured and changed all those formulas to the number the formula created and it says it is an error and says "This cell in inconsistent with the column formula. " maybe this has something to do with it.
In some cells, I have formulas like this "=14.98+15.57" instead of "=SUM(14.98+15.57)" maybe that is why?
I don't think above are reasons, something else.
- Do you have an idea of what the problem would be?
You may check this Getting this msg "Excel ran out of resources while attempting to calculate one or more formulas." - Microsoft Tech Community thread, lot of samples why such error appears. Usually incorrect array formula.
- It gives me this error when I try to exit out of the workbook as well.