Forum Discussion
Solved
Getting error "Getting error "Excel ran out of resources...."
EDIT solution provided to me below. Thanks all. Getting error "Excel ran out of resources while trying to calculate one or more formulas. As a result these formulas cannot be evaluated. " Doi...
- I'm afraid I'm at bit of a loss as to what the problem could be. The file you uploaded has not given me any errors, so I'm not able to reproduce the problem.
Thanks...that memtest sound good but I think it takes quite a while? I did quick Crucial scan which checks for available upgrades from them, and my PC scored above average. And I have worked with huge excel files on here- a million rows, but not much computation in those, just storage really.
My other excel files are working, but none have a formula as complicated as this type
=IF(W2="","",SUM(W2+H$6))
which appears in approx 1000 cells in the sheet, in a few columns. BUT even when I delete all instances of this formula, I get the error. At this point even if I enter the number 1 into a blank cell the error pops up.
Can an excel file get corrupted by a formula, and the corruption persist even after formula removed?
I'm afraid I'm at bit of a loss as to what the problem could be. The file you uploaded has not given me any errors, so I'm not able to reproduce the problem.
- Belated thank you. I am rebuilding the sheet- not a huge deal so not worth the effort to track down error.
BTW interesting thing I should mention is I realized when that error prone file was open, and I opened another excel file while the error file stayed open, the same problem started occuring in the other excel file. When I closed the error file, the other excel files behave fine. Bizarre,- I'm sorry I couldn't be of more help. I've never had a workbook misbehave in the manner you describe and, unfortunately, the sample workbook didn't act up for me. Hopefully, rebuilding it takes care of it. Good luck.