Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I'm trying to write a code that will clear all of the pivot filters that I may have selected while using a pivot chart to view my data. A lot of times I will select only 2 out of my 10 products for the x axis, 1 out of my 5 geographies as a page filter, 4 of my 12 sales reps and so on. I am trying to create a macro that is linked to a button on the chart sheet that would clear all of my filters on all of the fields. Is this possible? Any ideas? Thanks! Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Clear All Filters | Excel Discussion (Misc queries) | |||
FileDialog Filters.clear | Excel Programming | |||
VB to clear any filters when closing a spreadsheet | Excel Discussion (Misc queries) | |||
How to clear all filters in worksheet for all columns | Excel Discussion (Misc queries) | |||
Auto Open - Clear all filters | Excel Programming |