Excel Cannot Complete this task

[Mike H.]

I just rolled out an application and users are getting this error:
"Excel cannot complete this task with available resources. Choose less data
or close applications."

I checked the calculation tab of Tools>Options and the Update Remote
References is checked. And I have to update remote references. Any ideas
how I can get rid of the error message and still get the data updated? There
is an enormous amount of calculations that rely on another spreadsheet. I
don't get this error on my pc.

 

[Gary Keramidas]

here is some info
http://www.decisionmodels.com/memlimitsc.htm