Pivot Table Automatically updation problem

[dharmendra.keshari]

Dear All,

i have three pivot table in a sheet. if i change first pivottable
currentpage value, i want to change same value automatically change
other pivot table 2 and 3 with the private sub method.

Regards
Dharmendra Keshari

 

[Roger Govier]

Hi

take a look at this example file from Debra Dalgleish
http://www.contextures.com/PivotMultiPagesChangeAll.zip