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

You may be experiencing a memory leak.

http://www.google.com/search?hl=en&n...i=&safe=images

Cliff Edwards

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" wrote:

You may be experiencing a memory leak.

http://www.google.com/search?hl=en&n...i=&safe=images

Cliff Edwards

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

Cliff Edwards

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" wrote:

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

Cliff Edwards

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