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.
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.
Philster , you are welcome.
No problem, I don't care about best responses. More important you know now what was the reason. Even if workbook is rebuilt that could help in future.