clear filter on open of form

D

deb

Is there a way to clear all pivot table filters when the form is opened?
When the pivot table form is opened it has old filters still showing.
I am afraid the users will not notice the filter and mistake this for all
data showing.

Thanks bunches,
 
M

Maurice

Deb,

Try placing the following in the onload of the form:

me.filteronload=false

see if that does the trick.
 
Top