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