| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Any way to apply a filter automatically after changing a cell? | Excel Discussion (Misc queries) | |||
| Apply Filter to source of Pivot Table | Excel Worksheet Functions | |||
| Apply autofilter selections to 2nd table automatically? Macro? | Excel Worksheet Functions | |||
| Apply a formula as a pivot table calc or suggestion | Excel Worksheet Functions | |||
| Macro for Pivot Table - Apply to multiple workbooks | Excel Programming | |||
Hybrid Mode
