I use PowerPivot to consolidate my data due to the amount of data for my analysis. Unfortunately I can't figure out how to set a single PivotItem.visible = false like it would work with VBA and normal PivotTables.
I thought it should look like this :
ActiveSheet.PivotTables("PivotTable1").PivotFields("[Import].[K].[K]").PivotItem("[Import].[K].&[C]").Visible = False
which returned Error 438 - object doesn't support attribute or method.
Does anybody know how to fix it?
Thank you very much in advance!!
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?