Forum Discussion
Getting error "Getting error "Excel ran out of resources...."
- I'm afraid I'm at bit of a loss as to what the problem could be. The file you uploaded has not given me any errors, so I'm not able to reproduce the problem.
Like Mr. Jeff Blakley (@ JMB17) You informed, I can only confirm that your file can also be opened with my Excel without problems and works perfectly.
It could probably have been array formulas.
If one does not limit the row area in an array formula, it can lead to considerable time delay.
Instead of whole columns like $ B: $ B, only use the actual cell ranges (e.g. $ B2: $ B150000).
This brings a considerable acceleration from the former approx. 3:30 minutes to approx. 10 seconds, the time difference can be considerable.
Here is some additional information from Microsoft, what could have been the reason.
"Excel cannot complete this task with available resources" error occurs in Excel 2010
I wish you continued having fun with Excel
Nikolino
I know I don't know anything (Socrates)
