Excel has various limitations, including amount of memory it uses, that affect it. Large workbooks, complex formulas, array formulas that create large tables in memory, are some issues that can cause it to run out of resources. This site has some additional information that might be worth reading.
http://www.decisionmodels.com/memlimitsc.htm
