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