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

Copper Contributor

I am having an issue with the excel sheet which keeps showing me this issue "Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas can not be evaluated.". I have followed the step I'm googling to fix this error but nothing changed.

 

Never seen this before- pls guide me.

 

 

1 Reply

@fatinGalaxy 

Most probably you are on Excel with dynamic arrays (365) and have formula which generates wrong spill. If you are on Pro version you may try Inquire to find such formula. Or try to remove sheets/ranges one by one on copy of your workbook to localize an issue. Or share with us your workbook removing sensitive data from it.