Greetings All,
I have two Pivot Tables on a worksheet ... PivotTable2 and PivotTable3.
I am using VBA as part of the Worksheet_Activate event.
Everything was working fine until today. Now, I get an error that cannot get the PivotItems property class.
Anyone know of what is happening? How to correct this?
Thanks,
Steve
I have two Pivot Tables on a worksheet ... PivotTable2 and PivotTable3.
I am using VBA as part of the Worksheet_Activate event.
VBA Code:
...
Sheet4.PivotTables("PivotTable3").PivotCache.Refresh
With Sheet4.PivotTables("PivotTable3").PivotFields("Years Total")
.ClearAllFilters
.PivotItems("0").Visible = False
End With
With Sheet4.PivotTables("PivotTable3").PivotFields("Component")
.ClearAllFilters
.PivotItems("0").Visible = False
End With
Sheet4.PivotTables("PivotTable2").PivotCache.Refresh
With Sheet4.PivotTables("PivotTable2").PivotFields("Years Total")
.ClearAllFilters
.PivotItems("0").Visible = False
End With
With Sheet4.PivotTables("PivotTable2").PivotFields("Category")
.ClearAllFilters
.PivotItems("0").Visible = False
End With
...
Everything was working fine until today. Now, I get an error that cannot get the PivotItems property class.
Anyone know of what is happening? How to correct this?
Thanks,
Steve