Hi,

I have a workbook with pivot tables on each worksheet. Each pivot has the
same "page" (the name of a person).

When I wish to change the name of the person, I have to go into each
worksheet and manually change the "page". There are about 10 pivots. Is
there a way that I can change the "page" on one pivot and it then changes all
of the other pivots ?

Many Thanks
Pete

You can do this with programming. There's a sample file he

http://www.contextures.com/excelfiles.html


Under Pivot tables, look for 'PT0008 - Change Multiple Page Fields'


Pete wrote:
Hi,

I have a workbook with pivot tables on each worksheet. Each pivot has the
same "page" (the name of a person).

When I wish to change the name of the person, I have to go into each
worksheet and manually change the "page". There are about 10 pivots. Is
there a way that I can change the "page" on one pivot and it then changes all
of the other pivots ?

Many Thanks
Pete


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

I downloaded this sample and I still don't know what areas to change to make
this macro work for me. I was checking the worksheet names in the
spreadsheet and I couldn't really find it referenced in the macro...
--
mnwankpah


"Debra Dalgleish" wrote:

You can do this with programming. There's a sample file he

http://www.contextures.com/excelfiles.html


Under Pivot tables, look for 'PT0008 - Change Multiple Page Fields'


Pete wrote:
Hi,

I have a workbook with pivot tables on each worksheet. Each pivot has the
same "page" (the name of a person).

When I wish to change the name of the person, I have to go into each
worksheet and manually change the "page". There are about 10 pivots. Is
there a way that I can change the "page" on one pivot and it then changes all
of the other pivots ?

Many Thanks
Pete


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html