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?

To use a pivot table the data must be in memory.

There is the option on setting up a pivot table to use the same sourc
as another PT, rather than duplicating the data.

Otherwise you might try un-checking the option to "Save data with tabl
layout" , close the workbook, then re-open and continue. I have no
tried this

--
Message posted from http://www.ExcelForum.com