M
MichaelR
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
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