Hi,

I am using a macro do fill automatically several sheets completely filled
with pivot table (which everyone of them have different criteria). Sometimes,
criteria (report filter) are not in my import table so they don't appear on
the pivot table, but next time the criteria is back, it fill out every pivot
table.

My question is how can I freeze the pivot table in order to specify the
report filter once and that it always appear, data be there or not.

Thanks!
--
Mathieu