Is it possible to edit multiple pivots at one time?

Say I have 5 pivot tables that all have in the drop down menu "Geography" in
A4. I would like to know if excel has a capability to select say Americas
from the drop down box and the same be selected and updated for every pivot
you have within the file. I thought perhaps my hitting ctrl and selecting
all tabs and then selecting the geography I wanted it would work but it says
it cannot do that...Does anyone know if there is a solution?

There's a sample file here that you could adapt to your workbook:

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

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

MichelleO wrote:
> Say I have 5 pivot tables that all have in the drop down menu "Geography" in
> A4. I would like to know if excel has a capability to select say Americas
> from the drop down box and the same be selected and updated for every pivot
> you have within the file. I thought perhaps my hitting ctrl and selecting
> all tabs and then selecting the geography I wanted it would work but it says
> it cannot do that...Does anyone know if there is a solution?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Sorry there is no easy solution. Depending on what version of Excel you are
using (above Excel 2000) you could catch the pivot table change event and
update the other pivot tables accordingly...
--
HTH...

Jim Thomlinson


"MichelleO" wrote:

> Say I have 5 pivot tables that all have in the drop down menu "Geography" in
> A4. I would like to know if excel has a capability to select say Americas
> from the drop down box and the same be selected and updated for every pivot
> you have within the file. I thought perhaps my hitting ctrl and selecting
> all tabs and then selecting the geography I wanted it would work but it says
> it cannot do that...Does anyone know if there is a solution?

I am going to have to buy your book.
--
HTH...

Jim Thomlinson


"Debra Dalgleish" wrote:

> There's a sample file here that you could adapt to your workbook:
>
> http://www.contextures.com/excelfiles.html
>
> Under Pivot tables, look for 'Change Multiple Page Fields'
>
> MichelleO wrote:
> > Say I have 5 pivot tables that all have in the drop down menu "Geography" in
> > A4. I would like to know if excel has a capability to select say Americas
> > from the drop down box and the same be selected and updated for every pivot
> > you have within the file. I thought perhaps my hitting ctrl and selecting
> > all tabs and then selecting the geography I wanted it would work but it says
> > it cannot do that...Does anyone know if there is a solution?
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

Thanks! <g>

Jim Thomlinson wrote:
> I am going to have to buy your book.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html