Forum Discussion
Excel ran out of resources while attempting to calculate one or more formulas.
Please see attachment (screenshot). How can I correct my formulas so this message does not appear? Thank you.
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?
It gives me this error when I try to exit out of the workbook as well.