![]() |
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