Hello, I have found code that successfully let me de-select all PivotItems in a specific PivotField. The trouble I am having is then selecting specific items from a list. When I try to use the following code:

With ActiveSheet.PivotTables("Query_Data").PivotFields("Begin_time")
.PivotItems("11-Jun").Visible = True
.PivotItems("12-Jun").Visible = True
.PivotItems("13-Jun").Visible = True
End With

I get the following error:

'Unable to set the Visible property of the PivotItem class'

can anyone help? If there is another way to do this all toghether I am open to anything that works! The goal is to automatically select which items will be included and which will not for a specific PivotField.

many thanks in advance,
mb