M
mserber
I have an existing Pivot Table and want to use VBA code to select item
from a dropdown list.
When I execute the following code, I get the error message: Unable t
get the PivotItems property of the PivotField class,
ActiveSheet.PivotTables("PivotTable3").PivotFields("Group").PivotItems(parm_file_workbook).Visibl
= True
I've checked the Pivot Table Name and "PivotTable3" is correct. Th
parm_file_workbook value is "AIM", which is a valid value in th
"Group" field.
I've also tried adding the following code before execute the abov
code: ActiveSheet.PivotTables("PivotTable3").PivotCache.Refresh, bu
that did not solve the problem.
I've done some research and found that several people have receive
this error. However, none of the proposed solutions seemed to work o
address this specific problem.
Can anyone help me
from a dropdown list.
When I execute the following code, I get the error message: Unable t
get the PivotItems property of the PivotField class,
ActiveSheet.PivotTables("PivotTable3").PivotFields("Group").PivotItems(parm_file_workbook).Visibl
= True
I've checked the Pivot Table Name and "PivotTable3" is correct. Th
parm_file_workbook value is "AIM", which is a valid value in th
"Group" field.
I've also tried adding the following code before execute the abov
code: ActiveSheet.PivotTables("PivotTable3").PivotCache.Refresh, bu
that did not solve the problem.
I've done some research and found that several people have receive
this error. However, none of the proposed solutions seemed to work o
address this specific problem.
Can anyone help me