Forum Discussion
lklatt1012
Aug 10, 2021Copper Contributor
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 that spot to a $0.00
I reinstalled Office programs 64 bit - that did not help
I tried changing to manual and that helps but, I don't think I would want to keep it in manual. I don't know enough in regards to this portion of excel to know if that is not recommended or not.
Thanks!
I commented this formula, not sure what you'd like to calculate here. With that it works.
6 Replies
Sort By
- JMB17Bronze ContributorA 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.JMB17 , nope, only one such
I commented this formula, not sure what you'd like to calculate here. With that it works.
- lklatt1012Copper ContributorThank you that helped and I am no longer getting the error!
I appreciate the Response!lklatt1012 , you are welcome. It's also worth to clean empty space as JMB17 suggested.