ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Clear pivot fields - please help (https://www.excelbanter.com/excel-programming/412725-clear-pivot-fields-please-help.html)

MichaelR

Clear pivot fields - please help
 
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


All times are GMT +1. The time now is 07:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com