I have a series of pivottables on different tabs.

I have the first one updated from an MS access database. The rest of
the pivottables are all built on the data from the first pivot table.

I have a macro set up to do the requery to the database which works
fine - however, when I try to get code to refresh the rest of the
pivotTables, which are built on the dataset from the first, i am
running into all sorts of problems. Any idea on how I should be writing
a macro to get the data to refresh properly based on the first
pivotTable?