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

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

Can I apply automatically the same filter on many 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"

--
Regards,
Tom Ogilvy


"mathieuvv" wrote:

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