Hi all,

I have a sheet called "Report" which contains 3 separate pivot table all with the common field "Division". I would like the other 2 pivots to change to the Division I select from the field called "Division" on the first pivot table without having to select them manually.

Any help gratefully received.
thanks
x