Web quieries and memory
 

I have a workbook that i recently updated. At first, it had about 20+
pages each with its own web query. I had one cover page that looked up
(several vlookup formulas) the values on each sheet according to the
date and compiled the information I needed.

On the updated version, I combined all the individual sheets (with
individual quiries) into one sheet. I spread the web quiries out (cell
a1, g1, j1, etc..). I still used the same cover sheet to retrieve the
data I need.

Now, the file has more than tripled in size (53Mb) and I am having
issues with even getting it open. When I run the macro to update the
quiries on the sheet, now it takes forever, locks up, or returns the
message that i dont have enough memory.

I thought reducing the number of sheets (20+) to 1, and combining the
quiries would help reduce the memory however the opposite has
happened.

Any suggestions? (store the quireies somewhere else? update on
open?.....)

thanx....j

Web quieries and memory
 

Without seeing the details maybe you could have ONE query get the dataredo
the query with the new variableget the dataetc. I did something similar
recently for a client to retrieve 4000 days of currency trading for about 40
sets of trades.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"J.W. Aldridge" wrote in message
ps.com...
I have a workbook that i recently updated. At first, it had about 20+
pages each with its own web query. I had one cover page that looked up
(several vlookup formulas) the values on each sheet according to the
date and compiled the information I needed.

On the updated version, I combined all the individual sheets (with
individual quiries) into one sheet. I spread the web quiries out (cell
a1, g1, j1, etc..). I still used the same cover sheet to retrieve the
data I need.

Now, the file has more than tripled in size (53Mb) and I am having
issues with even getting it open. When I run the macro to update the
quiries on the sheet, now it takes forever, locks up, or returns the
message that i dont have enough memory.

I thought reducing the number of sheets (20+) to 1, and combining the
quiries would help reduce the memory however the opposite has
happened.

Any suggestions? (store the quireies somewhere else? update on
open?.....)

thanx....j