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 | |||
PivotTable - Clear all data fields | Excel Programming | |||
clear contiguous fields with one keystroke | Excel Programming | |||
A Fix - Pivottable - Added calculated fields and now can't clear pivot | Excel Programming | |||
Pivottable - Added calculated fields and now can't clear pivot | Excel Programming | |||
How do I Clear old Pivot Table Fields that no longer exist | Excel Discussion (Misc queries) |