clear pivot filter

  • Thread starter Thread starter deb
  • Start date Start date
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,
 
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
 
Back
Top