clear filter on open of form

[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,

 

[Maurice]

Deb,

Try placing the following in the onload of the form:

me.filteronload=false

see if that does the trick.