If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VBA Refreshing Pivot Tables without losing Filter selection

Thread starter btadams
Start date Oct 4, 2018
Tags

filter macro pivot site tables

btadams

Well-known Member

Oct 4, 2018

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