How to "reset" pivot table view?

[Atomsk]

I'm trying to manipulate the FilterMembers property of the OWC9
pivotTable so that clicking on a button will "reset" the pivot table
view by including all filter members. The way that my table is set up
only allows for a "manual" drilldown, and it's a pain to go back and
click the "(Show all)" setting for all the columns you've changed.


PivotTable.ActiveView.DataAxis.FieldSets(0).Fields(0).FilterMembe-
rs = ("all")


^^The above manipulates only the first recordset (column) of my table
for testing purposes. If I change the included members for this column,
then click the 'reset' button, it initially appears to work, and all
members are displayed. However, when I go to see which members are
selected (it should be all of them), none of them are. It works fine if
I define a specific member, or an array of members, but it won't work
with an array of ALL members.

I though it might also be a conflict between different settings, like
selecting (Show all), (Blank), and (Nonblank) so I tried


PivotTable.ActiveView.DataAxis.FieldSets(0).Fields(0).FilterMembers =
("(Show all)")


but the end effect is the same. Any help is greatly appreciated.

 

[Dan Ricker]

The 4th toolbar button is the "AutoFilter" button.

1) Set filtering as desired
2) Click "AutoFilter" button - No filtering is applied
3) Click "AutoFilter" button - Previous Filtering is
reapplied.
4) Click "AutoFilter" button - No Filtering is applied
5) Set filtering on some field/fieldset
a) AutoFilter automatically "ON"
b) All previous filtering removed
c) New filter state used when AutoFilter Toggled.

 

[Atomsk]

Thanks very much.