clear pivot table filters or disable dropdowns

[deb]

I am using a QBF to set the criteria for a Pivot Table.

How can i either:

1. Clear all pivot table old filters each time the pivot is opended?
or
2. Disable the pivot table dropdowns all together.

Thanks