You may be able to do this with a Macro or VBA, but, AFAIK there is no Pivot
Table feature that allows you to "synchronize" separate Pivot Tables. |:)

"Kirk P." wrote:

I've got a pivot table, one on each sheet. Both pivot tables display similar
information, but in slightly different ways. Question is, can I set it up so
BOTH pivot tables respond to changes in the "page" dimension of one pivot
table.

It would be nice to change the "Year" dimension in PT1 and have that year
carry across to PT2. Currently, I have to change the year in BOTH pivot
tables manually.

Any ideas?