![]() |
Unable to get the PivotItems property of the PivotField Class
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? |
All times are GMT +1. The time now is 06:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com