Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL 2007 - Out of Memory - memory leak/bug? | Excel Discussion (Misc queries) | |||
Not Enough Memory | Excel Discussion (Misc queries) | |||
Out of Memory | Excel Programming | |||
The instruction at "0x65255ac9" referenced memory at "0x00000008". The memory could not be read. Clikc OK to terminate etc | Excel Programming | |||
VBA Memory jog! | Excel Programming |