Filtering PivotTable results based on a list on another worksheet

[glitch]

First of all, I am relatively new at using Excel for work, so I am sorry if my question is very basic.

I'm working with data that includes a dozen or so items that shouldn't be part of the PivotTable calculation. I would like to have to avoid checking/unchecking the items in the filter field every time I analyze another version of the data. What's the best way of going about it?

 

[UniMord]

Welcome aboard the Board!

Here's a quick and dirty solution. Remember, if there are no values left, you're going to get an error, so you might want to check for that first.

I set up Exclude_These as a Named Range on a different sheet.
Enter the correct Sheet Name, Table Name, and Field Name.
Run this from a button or have it fire on on any PivotTable event of your choice, and voila!

Sub ExclFromList()
    Dim PField As PivotField
    Set PField = Worksheets("Sheet Name").PivotTables("Table Name").PivotFields("Field Name")
    Dim ExclItem As Range
 
    Application.ScreenUpdating = False
    With PField
        For Each ExclItem In [Exclude_These]
            .PivotItems(ExclItem.Value).Visible = False
        Next ExclItem
    End With
    Application.ScreenUpdating = True
End Sub