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!


--
polaro
------------------------------------------------------------------------
polaro's Profile: http://www.excelforum.com/member.php...o&userid=25370
View this thread: http://www.excelforum.com/showthread...hreadid=388522

Would like to ask assistance in filtering multiple pivots atthe same time
 

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

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

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

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

--
polar
-----------------------------------------------------------------------
polaro's Profile: http://www.excelforum.com/member.php...fo&userid=2537
View this thread: http://www.excelforum.com/showthread.php?threadid=38852