Excel ran out of resources while attempting to calculate one or more formulas

[ck35]

I had an issue with a 2010 spreadsheet that has a number of sumproduct formulas (around 690).
I wanted to pass this on if anyone else that might be having this type of issue..
I read in one of the forums that changing to 64 bit would help this issue, but I also heard that this Excel cause other issues so choose not to go there...
Just for giggles I save the spreadsheet to .XLS instead of the .XLSM and ran in capiblity mode...It worked and faster too...
So give it a try.
CK35

[dilipandey]

Hi ck35,

welcome to the forum.
I have something to add here :-

As an option, change the workbook calculation mode to "manual" and press "shift + F9" to calculate the sheet having sumproduct formulas


Regards,
DILIPandey
<click on below * if this helps>

[ck35]

Just an FYI...I had the spreadsheet in that Manual calculate and I repeatedly got the error message. The only thing I found to work was as I stated running in compiblity mode.
Thank you for your input...
CK35