Hello, Roger, and many thanks

I already did check these files by Debra Dalgleish. And they're awsome. The
thing is I can't seem to find quite what I need

I need a macro to change all the filters in all my PTs at once. Example


YEAR 2007
TYPE OF EQUIPMENT Microwave

Yes 120
No 77
Only partially 99

I need the macro to do this:

YEAR 2007
SELLER Michael

Yes 101
No 33
Only partially 31


I'm not sure if I'm making myself clear, I'm not experienced with macros or
with VBA...

Thanka again!!!!
"Roger Govier" wrote:

Hi

Take a look at the sample workbook created by Debra Dalgleish
http://www.contextures.com/PivotMultiPagesChangeAll.zip
--
Regards
Roger Govier

"Augusto_Madrid" wrote in message
...
How can I modify all my pivots at once?

I have some 200 PT and I need them to switch from one filtering variable
to
another, ie. if I am filtering by "year" and "type of equipment" (as
general
filters, not as rows or columns), and I would need "type of equipment"
replaced by "Seller" in all my Pivot Tables

Can this be done?

Thanks in advance!