Excel ran out of resources
GenBp
Posted messages
1
Registration date
Status
Membre
Last intervention
-
Raymond PENTIER Posted messages 58546 Registration date Status Contributeur Last intervention -
Raymond PENTIER Posted messages 58546 Registration date Status Contributeur 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!
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 réponse
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)
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)