There's nothing built in that will synchronize the pivot tables. You
could use programming to make the page field selections the same.
There's a sample file he

http://www.contextures.com/excelfiles.html

Under Pivot Tables, look for 'PT0008 - Change Multiple Page Fields'

KJ wrote:
New question:
If I extract two pivot tables from the same data source (because I need them
summarized in different ways), can I have the second table reference the same
filter as the first? ei: I want both to filter for the month of January, is
there a way to have Table B automatically changed? Or can I have filters
from other pivot tables basically synched?

"KJ" wrote:


I'm familiar with the GETPIVOTDATA function, my issue is that the report I
work on, I need the output of the pivot table, plus extra calulations of that
data on the same page.

"HKaplan" wrote:


You need to use the GETPIVOTDATA function. Search Help and it will
guide you through it.

Don't put your formulas next to the pivot table. Try to locate them
elsewhere if possible.




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html