I have an existing Pivot Table and want to use VBA code to select items
from a dropdown list.

When I execute the following code, I get the error message: Unable to
get the PivotItems property of the PivotField class,

ActiveSheet.PivotTables("PivotTable3").PivotFields ("Group").PivotItems(parm_file_workbook).Visibl e
= True

I've checked the Pivot Table Name and "PivotTable3" is correct. The
parm_file_workbook value is "AIM", which is a valid value in the
"Group" field.

I've also tried adding the following code before execute the above
code: ActiveSheet.PivotTables("PivotTable3").PivotCache. Refresh, but
that did not solve the problem.

I've done some research and found that several people have received
this error. However, none of the proposed solutions seemed to work or
address this specific problem.

Can anyone help me?