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!

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!

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!

Debra's example looks to be exactly what you need
The VBA checks the name of each PAGE field of the main pivot and then, if
those fields are in other pivot table page fields, then they'll be set to
the same value

however, because they use the pivot change event, they fire each time a
change is made. You'll need to copy the code to a standard module, making it
a parameter-less sub, and call it once all changes to the "main" pivot have
been made. Unless therepivots are very complex, i can't see much benefit
to doing it this way

"Augusto_Madrid" wrote in message
...
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!

Following with this example from Debra, what I need is all the tables to be
filtered by Unit cost if I change Item by Unit cost in the Main Pivot Table.

What I see here is that I can choose Quebec or Ontario, and all PTs change
to Quebec or Ontario...

Am I too wrong?
You are being so patient and helpful, thanks SOOO much

"Patrick Molloy" wrote:

Debra's example looks to be exactly what you need
The VBA checks the name of each PAGE field of the main pivot and then, if
those fields are in other pivot table page fields, then they'll be set to
the same value

however, because they use the pivot change event, they fire each time a
change is made. You'll need to copy the code to a standard module, making it
a parameter-less sub, and call it once all changes to the "main" pivot have
been made. Unless therepivots are very complex, i can't see much benefit
to doing it this way

"Augusto_Madrid" wrote in message
...
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!

ah. So you need to change the field itself? yes, that too can be done.
you just need to amend DD's code to read read the page field names and
update the other pivots

"Augusto_Madrid" wrote in message
...
Following with this example from Debra, what I need is all the tables to
be
filtered by Unit cost if I change Item by Unit cost in the Main Pivot
Table.

What I see here is that I can choose Quebec or Ontario, and all PTs change
to Quebec or Ontario...

Am I too wrong?
You are being so patient and helpful, thanks SOOO much

"Patrick Molloy" wrote:

Debra's example looks to be exactly what you need
The VBA checks the name of each PAGE field of the main pivot and then, if
those fields are in other pivot table page fields, then they'll be set to
the same value

however, because they use the pivot change event, they fire each time a
change is made. You'll need to copy the code to a standard module, making
it
a parameter-less sub, and call it once all changes to the "main" pivot
have
been made. Unless therepivots are very complex, i can't see much
benefit
to doing it this way

"Augusto_Madrid" wrote in
message
...
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!