clear pivot filter

D

deb

In a Pivot table...
If a user filters a field by selecting with the field dropdown.
Then closes Pivot table and reopens, the filter is still there.

How can I clear the filter when the Pivot table is closed?

Thank you,
 
D

deb

Please HELP.

I have tried both...
Me.Filter = ""
Me.FilterOn = (False)
nothing happened

I tried
RunCommand acCmdFilterByForm
RunCommand acCmdClearGrid

Error 2046
Command or action isn't available now

Then only wat to clear is to un-click the AutoFilter button.
How can I have this unclicked on form open or form close
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turning a 3 column flat file into a "3D" Table 2
GETPIVOTDATA function on pivot filter 0
Can't make filter crosstabquery via criteria->build->forms-> Loade 4
Pivot table issue 1
Storing Multiple Selected Pivot Table Report Filter Values 2
Pivot Table Calculating Field Help 1
Pivot using 250,000 rows of data in Excel? 1
Percentages in Pivot table 2

Top