error code in excel

Copper Contributor

JeffPommier_0-1612470611797.png

anyone know how to resolve?

How can I resolve this error? "excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated." this shows up after i complete data in each cell!

1 Reply

@JeffPommier 

I assume this is a huge spreadsheet, right?

 

Are there parts of the spreadsheet where calculations have been done and are no longer needed to be there as formulas? If so, you could do a Copy..Paste Special and just copy over the fixed results in the same place, replacing the formulas with the fixed results.

 

Obviously, close other apps that are using computing space.....things like that.