Can I apply automatically the same filter on many pivot table ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a file with 5 pivot table
Each time I want to filter, I have to go on each pivot table to do the same
filter
How can I automize this ?
My pivot table are linked and when I update the first one, the others are
updated too
but I didn't find how I could activate the same filter on each pivot table
 
There is no built in support for this. You would have to write a macro that
goes to each table and sets the "filter"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

GETPIVOTDATA function on pivot filter 0
change pivot table in code 3
Storing Multiple Selected Pivot Table Report Filter Values 2
Using VBA on Excel Pivot Tables 3
Pivot table multiple filters 2
Help list box to update pivot table 1
Corrupt files due to pivot remnants after saving via VBA 0
Get visible pivot table items 4

Back
Top