22.0k views
8 votes
Excel ran out of resources while attempting to calculate

1 Answer

9 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 Deadlock
by
4.5k points