Linking Pivot Tables
 

Hi,

I have a workbook with several worksheets, each of which contain a pivot
table. Each pivot table has the same "page" (a person). When I wish to
change the name of the person, I have to go into each worksheet and change
the "page" on all the pivot tables manually.

Is it possible for me to change the person's name on one of the pivots and
for the other pivots to change automatically ?

Many Thanks
Pete