View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default Excel Cannot Complete this task

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

--


Gary


"Mike H." wrote in message
...
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.