clear filter on open of form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

deb - 14 May 2008 14:09 GMT

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,

Signature

deb

Reply to this Message

Maurice - 15 May 2008 08:33 GMT

Deb,

Try placing the following in the onload of the form:

me.filteronload=false

see if that does the trick.

Signature

Maurice Ausum

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

Reply to this Message