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 ToolsOptions 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.