What is your trigger to refresh. When you open the book or every ?? minutes?
or...

There are some options in Table Options. Right click the pivot table and
select Table Options. At the bottom are the refresh options (IIRC for 2000).
--
HTH...

Jim Thomlinson


"Shell" wrote:

In Excel 2000, I have a spreadsheet with several table. Some of the tabs
have been filled with data from an Access MDB. I have manually created a
second tab which contains a pivot table based on the data I passed in to the
ther tab.

The source data tab always has a different number of rows every time the
Access MDB is executed.

How can I automatically refresh the pivot table?

Thanks
--
Shell