I have a sales Worksheet. It has data on one sheet that
is created from a query and is over 35,000 rows long.

I also have two pivot graphs, and 5 pivot tables.

So that the users don't have to do anything I have a
script that updates the data, then updates each pivot
table.

Unfortunatly the system gets as far as updating the data
and two tables, then half way through the third table it
alters the virtual memory settings and slows down to a
crawl.

Is there any way in visual basic to clear down the memory
used after each table update?