I'd like to make a button that, when clicked, resets the view of my pivot table so that all filters have all of their elements selected. The following line does this:
PivotTable.ActiveView.DataAxis.FieldSets(0).Fields(0).FilterMembers = Array("all"
When I click the button that this is bound to, the table does display all values (from whatever it was displaying before), but when I click to see which elements are selected (it should be all of them), none of them are actually checked. This is messing up the rest, since I have to reset the filters for each individual recordset. Thanks for any help.
PivotTable.ActiveView.DataAxis.FieldSets(0).Fields(0).FilterMembers = Array("all"
When I click the button that this is bound to, the table does display all values (from whatever it was displaying before), but when I click to see which elements are selected (it should be all of them), none of them are actually checked. This is messing up the rest, since I have to reset the filters for each individual recordset. Thanks for any help.