View original (French)

Excel ran out of resources

GenBp Posted messages 1 Registration date   Status Member Last intervention   -  
Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   -
Hello,

I'm building an Excel template, and I don't really have much data. My formula is quite simple; it's a SUMPRODUCT with 6 arguments, but I'm immediately receiving the error message "Excel ran out of resources while trying to calculate one or more formulas. These formulas could not be evaluated."

What reasons could there be for receiving this message? Has anyone experienced this before?

Help me! I'm at my wit's end! Thank you so much, you are the best!

1 answer

  1.
    Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     
    Hello.

    I suppose that in Canada they use the terms
    template for file and data for data?
    The causes can be various:
    1) Used and outdated computer
    2) Insufficient memory (too many unnecessary files and temporary files not deleted)
    3) Too many programs open simultaneously
    4) Too many cells containing formulas with SUMPRODUCT

    We have no elements to help us make the right diagnosis.

    --
    Retirement is nice! Especially in the Caribbean ... :-)
    Raymond (INSA, AFPA, CF/R)
    0