If you perform a web search
"excel not enough memory"
Lot's of info on the subject, there is more then one answer, not much for solutions though.