Forum Discussion
JeffPommier
Feb 04, 2021Copper Contributor
error code in excel
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
Sort By
- mathetesSilver Contributor
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.