VBA Refreshing Pivot Tables without losing Filter selection

[btadams]

I have a feeling there's nothing that can be done, but I'm using a macro to create site-specific reports from a master file. So the macro filters the data so it just has data for a specific site and then it refreshes all the pivot tables in the workbook. So PivotTable #1 is filtering on Provider_Specialty and it should always be set to "Other". However, if a site does not have any "Other" providers, the filter changes to whatever type of provider that site has. Is there any way to keep that filter from changing? Or am I going to have to have the macro check to see if the filters on all pivot tables are what they are supposed to be?

Thanks,

Brian