Thread: Would like to ask assistance in filtering multiple pivots at the same time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default 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

Reply With QuoteReply With Quote