Forum Discussion

Copper Contributor

Oct 04, 2021

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.

Excel Screenshot correct as at 4 October 2021.docx154 KB

Formulas and Functions

Copper Contributor

Dec 27, 2021

This error is coming up on ALL of my workbooks. I have deleted formula data. I have deleted smaller not important workbooks. I have checked and traced errors. I cannot find them. I have a 64 bit office already. The error pops up every time I add something new or open a workbook.

Diamond Contributor

Dec 28, 2021

Could you share one of such workbooks removing sensitive information?

heavenlydough
Copper Contributor
Dec 30, 2021
SergeiBaklan
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?
- SergeiBaklan
  Diamond Contributor
  Jan 05, 2022
  heavenlydough
  
  I don't think above are reasons, something else.
  - heavenlydough
    Copper Contributor
    Jan 06, 2022
    Do you have an idea of what the problem would be?
- heavenlydough
  Copper Contributor
  Dec 30, 2021
  It gives me this error when I try to exit out of the workbook as well.

Resources