Forum Discussion
Solved
Excel ran out of resources while attempting to calculate one or more formulas
I cannot get this excel document to perform any new formulas. Everything I try to do since I received this error doesn't perform the entered function. If I try to Sum a block of cells it just turns t...
I commented this formula, not sure what you'd like to calculate here. With that it works.
A few things I noticed that I think are part of your problem.
1) Your used range includes a lot of empty cells. If you hit Ctrl+End it will take you to the last cell in the used range and you can see it includes a lot of empty space. Reset the used ranges on the worksheets:
https://www.toolbox.com/tech/data-management/question/how-to-reset-used-range-in-excel-052010/
2) You have a lot of empty formatted cells (colored), but should be corrected when you reset the used range.
3) You have this formula on the Project Cost Tracking worksheet, cell CE1:
=+CP:CCE
If you have office 365, this formula will return 2,116,026,368 cell values and probably causing a lot of your problem. I would look over the workbook to see if you have any other references like that.
1) Your used range includes a lot of empty cells. If you hit Ctrl+End it will take you to the last cell in the used range and you can see it includes a lot of empty space. Reset the used ranges on the worksheets:
https://www.toolbox.com/tech/data-management/question/how-to-reset-used-range-in-excel-052010/
2) You have a lot of empty formatted cells (colored), but should be corrected when you reset the used range.
3) You have this formula on the Project Cost Tracking worksheet, cell CE1:
=+CP:CCE
If you have office 365, this formula will return 2,116,026,368 cell values and probably causing a lot of your problem. I would look over the workbook to see if you have any other references like that.
JMB17 , nope, only one such