setting pivot filter in multiple pivot tables

Good day,

the code I have works for the result needed, sets the filter on a pivot table based off an array of entries,

however, I have 12 pivot tables that have to be set to the same filters for products,

however this takes WAAAAAY tooo long .... would there be any suggestion on how to better manage all this information?

I am handling 3 years worth of data for different departments for different products in each department,

the file size is about 45 megs (40 of raw data, 5 of PivotTables and Pivot caches)

I tried separating the documents to see if that works better and have the pivots pull from another work book with the raw data ...

I have set Application.ScreenUpdating = False

Please Login or Register  to view this content.

is there a better way to filter a PT for multiple items??

thanks marvin, ill give it a go ^^

Best option was to just add another column to the raw data and just change 1 filter rather than multi-filter,