Forum Discussion
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.
I don't think above are reasons, something else.
Do you have an idea of what the problem would be?
You may check this Getting this msg "Excel ran out of resources while attempting to calculate one or more formulas." - Microsoft Tech Community thread, lot of samples why such error appears. Usually incorrect array formula.
Here is the solution ..
this error is a pain in the neck ...
Go to files/Options/ Formulas
Then , click on Manual and Uncheck Recalculate workbook
this is a good solution for those who don't eal with formulas and only keep records of simple things ..jameswall555 To everyone who has provided assistance to me regarding my post; firstly, thank you for that. Secondly, it was so long ago, that I don't even remember it, sorry, but thank you anyway.
