Would like to ask assistance in filtering multiple pivots at the same time

Greetings!

My Excel file contains a few dosen pivots.

Every week I manually filter the current week (week 1, week 2 etc) option in all pivots.

Is there any way to set a global control option to change all the pivots at once?

Thanks!

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

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

Under Pivot Tables, look for 'Change Page Field'


polaro wrote:
> Greetings!
>
> My Excel file contains a few dosen pivots.
>
> Every week I manually filter the current week (week 1, week 2 etc)
> option in all pivots.
>
> Is there any way to set a global control option to change all the
> pivots at once?
>
> Thanks!
>
>


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

Really appreciate it, the code will save me lots of time.