[pivottables] multiple table selection fields update in one click...

[a.lagolep]

Hi

On a worksheet, I have 100 pivot tables. Let's say one criteria of each
pivot table is "month"

Ho can I do in order to only type somewhere the month (let's say in A1
for example) and this month is then automatically populated to all
pivot tables ?

If this is easy... additional question : on the same worksheet, I have
100 pivot tables split in two columns. with the same "month "criteria.
How can I do to have A1 for month setting for the 50 pivot tables of
the 1rst column, and A2 to setup the month of the other 50 pivot table
list ?

Thanks,

AL.

 

[Debra Dalgleish]

There's a sample file here where changing a page field in one pivot
table changes the same field in other pivot tables:

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

Under PivotTables, look for 'PT0008 - Change Multiple Page Fields'

It might help you get started with your workbook.