Hi

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

--
Regards
Roger Govier

wrote in message
...
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