New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Apply filter to all pivots

Macros, VBA, Excel Automation, etc.

Apply filter to all pivots

Postby dee » Wed Dec 07, 2011 11:23 pm

I have 3 pivot tables in a sheet and for all data source and main filter is same. If i change main filter of first pivot table then it should change in all the pivot tables.
i am trying to do this in excel macro...can you help me on this?
  • 0

dee
Rookie
 
Posts: 2
Joined: Dec 7, 2011
Reputation: 0

Re: Apply filter to all pivots

Postby Don » Thu Dec 08, 2011 12:30 am

Hi!

Are you wanting to do this for one often used filter or have the filter options update no matter what was selected from the first pivottable?
  • 0

Don
Moderator
 
Posts: 733
Joined: Dec 4, 2011
Reputation: 2
Excel Version: 2010

Re: Apply filter to all pivots

Postby dee » Thu Dec 08, 2011 1:59 am

Hi,

Whenever i change the main filter in first pivot table same should apply for all the pivot tables in that sheet. I have 3 pivot tables in that sheet.
  • 0

dee
Rookie
 
Posts: 2
Joined: Dec 7, 2011
Reputation: 0

Re: Apply filter to all pivots

Postby emergingtech » Thu Dec 08, 2011 2:05 pm

Try creating a Slicer connected to the field in the pivot table you want to filter. Slicers are visual filter boxes created for Excel version 2010.
  • 0

emergingtech
Rookie
 
Posts: 1
Joined: Dec 8, 2011
Reputation: 0


Return to Macros and VBA Questions

Who is online

Users browsing this forum: No registered users and 73 guests