We have an Excel 2003 workbook that contains sixteen worksheets. The
first worksheet contains a pivot table that's linked to an external
data source (MS Access database). The rest of the worksheets contain
pivot tables that are based on the first pivot table.

We want to make one change in the data source for the first (master)
pivot table and apply it automatically to the rest of the pivot tables.
Can this be done programmatically? Right now, it appears that we'll
have to re-create the other 15 pivot tables in order to maintain the
single data source.

Andre