Hello. I've got three pivot tables attached to a data table on a worksheet. Each pivot table has five filters, with four of them being the same. Rather than have the user update the three pivot tables separately, I've got a small table where they enter the four parameters once. Then via a macro, I want the four filters in each of the pivot tables to get updated with the parameters the user entered. I've got it working nicely for the first filter (Country of Event, shown below), but it doesn't update subsequent filters. The Catalog # code below seems to work (no debug), but it doesn't update the pivot table. Everything I've found online is for updating multiple items within a filter. Is there something else I need to do to get the other filters to update, or is it a limitation to only be able to update one filter? Thanks for any advice.
'update Country of Event in pivot tables
Set xPTcoi = Worksheets("SIMPLE").PivotTables("PivotCOI")
Set xPFcoi = xPTcoi.PivotFields("Country of Event")
xStrCOI = Range("B4").Value
xPFcoi.CurrentPage = xStrCOI
'update Catalog # in pivot tables
Set xPTcoi = Worksheets("SIMPLE").PivotTables("PivotCOI")
Set xPFcoiCatalog = xPTcoi.PivotFields("Catalog #")
xStrCatalog = Range("B5").Value
xPFcoiCatalog.CurrentPage = xStrCatalog
Bookmarks