D
DG
I have an excel spreadsheet that has 21 sheets. 1 is the summary, 1 is the
template for sql query, and 19 are for the data. I am listing open orders
for 19 locations and summarizing it on a Summary Sheet. I have a macro that
uses the sheet name (ex 201 the location name) to query (SQL2000 database)
and retrieve data to the "template" sheet. It then copies the data from
the "template" sheet to the data sheet (ex Sheets!201). It does this for
all 19 sheets. While doing that it totals up information to put on the
summary sheet.
My users are getting the following error "Excel cannot complete this task
with available resources. Choose less data or close other applications." .
In task manager it shows 136,500 K Mem Usage when I open the file.
Everytime I process the macro it gets larger. Why? It's returning the same
data each time.
How do I make it smaller? Is it the queries or the sheets? The biggest
sheet has about 1000 lines with 10 columns. I'm not using any arrays.
Any help would be great.
DG
template for sql query, and 19 are for the data. I am listing open orders
for 19 locations and summarizing it on a Summary Sheet. I have a macro that
uses the sheet name (ex 201 the location name) to query (SQL2000 database)
and retrieve data to the "template" sheet. It then copies the data from
the "template" sheet to the data sheet (ex Sheets!201). It does this for
all 19 sheets. While doing that it totals up information to put on the
summary sheet.
My users are getting the following error "Excel cannot complete this task
with available resources. Choose less data or close other applications." .
In task manager it shows 136,500 K Mem Usage when I open the file.
Everytime I process the macro it gets larger. Why? It's returning the same
data each time.
How do I make it smaller? Is it the queries or the sheets? The biggest
sheet has about 1000 lines with 10 columns. I'm not using any arrays.
Any help would be great.
DG