Forum Discussion

Philster's avatar
Philster
Copper Contributor
Mar 04, 2021
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...
excel
office 365
  • JMB17's avatar
    JMB17
    Mar 05, 2021
    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.
JMB17's avatar
JMB17
Bronze Contributor
Mar 04, 2021
I can open it without issue. As you said, it's just data, so it certainly shouldn't be giving you this issue. Perhaps you had a ram module go bad and you don't actually have 8GB available (assuming you probably have 2 ram modules - Win10 will technically run on 4, but it's not recommended and would surely cause a lot of resource issues)?

I believe you could test it with this
https://www.memtest86.com/
  • Philster's avatar
    Philster
    Copper Contributor
    Mar 04, 2021

    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?

    • JMB17's avatar
      JMB17
      Bronze Contributor
      Mar 05, 2021
      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.
      • Philster's avatar
        Philster
        Copper Contributor
        Mar 09, 2021
        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,

Resources