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)
- Thank you. Yes, I had whole column formulas in there that only applied to a few hundred row. That was probably the problem...but strangely it persisted even when I removed the column long formulas. I just rebuilt to sheet- only took an hour, so was less work then tracking down error. Thanks again.
Most probably you are on Office365. In AM1 you have the formula which tries to return combinations of ranges from column A to column AM with intersection.
Not sure what did you mean here, but if remove this formula
it'll be no problems with your workbook at all, at least from performance point of view.
Not 100% sure, but on Excel without dynamic arrays most probably it shall be no problems with such combination.
You nailed it! Error is gone when I remove that.
Unfortunately I rebuilt the whole thing in last few days lol. Thanks again.Edit I can't list this as "best response" since I already gave that to a guy above who tried hard.
