out of memory errors

[dmoney]

I have written a very large macro, that pulls data from access via sql
statements -- copies and pastes data to new workbook then creates and
refreshes a pivot table in the new workbook. The pasted data is appox. 26
col by 500 rows. When I try and refresh the pivot table, i get the continue
without undo prompt followed by the out of memory msg. I noticed that the
file size of the new workbook is 15mb and have no idea why it is this large.
Any ideas? can I clear the memory before the refresh?

Thanks in advance.

Dmoney

 

[ward376]

You may be experiencing a memory leak.

http://www.google.com/search?hl=en&...=&as_occt=any&cr=&as_nlo=&as_nhi=&safe=images

Cliff Edwards

 

[Nico]

Is there a way to fix this? Clear the cache before restarting or something?
I haven't been able to find anything via Google.

Thanks.

 

[ward376]

Do you have the file you're querying open when this happens?

Cliff Edwards

 

[dmoney]

I open an existing workbook paste some data in it and attempt to refresh 3
pivot tables. The first and second pivot tables refresh ok and on the third
refresh command, Excel runs out of memory. I have tried saving changes
opening and closing befor refresh programatically to no avail. If i close
excel out and manually open only the file that i want to refresh and refresh
it manually, it works fine. I agree it must be a memory leak -- just have
not been able to figure out how to plug it. --- do u know how to refresh the
pivots without opening the file??

 

[ward376]

Make sure the file that is the source of your data is closed during
the refresh. If that doesn't help, post your code.

Cliff Edwards