257,875 views
42 votes
42 votes
Excel ran out of resources while attempting to calculate

User Mayank Pandeyz
by
2.3k points

1 Answer

20 votes
20 votes

Re: Excel ran out of resources while attempting to calculate one or more formulas

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 ...

You have a lot of empty formatted cells (colored), but should be corrected when you reset the used range.

You have this formula on the Project Cost Tracking worksheet, cell CE1:

User Gcahill
by
3.0k points