Excel cannot complete this task with available resources

D

DG

I am getting this error in excel:

Excel cannot complete this task with available resources. Choose less data
or close other applications.

I have Excel 2003 (11.8231.8221) SP3. My computer has 2.0 GB RAM. I closed
all other apps but excel.

The spreadsheet that I have has 19 tabs each with a query to an MS SQL
database. My vb code also does some formating, background color and
grouping of the returned data. The queries do not return much data. Most
tabs have less that 100 rows. (All have 10 columns). This biggest has only
1961 rows.

=info("memused") is 117,770,472
Any Ideas?

Dan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cannot complete with available resources. 0
"Excel cannot complete this task with available resources" 2
Memory problems with Excel 2010 0
Excel cannot complete this task with available resources. Choose l 0
Excel cannot complete this task with available resources 6
Excel Can't Complete This Task with Available Resources. 4
"Excel cannot complete this task with available resources." 1
Excel cannot complete this task with available resources. Choose l 1

Top