Powerpivot VBA: How to set a single Pivotitem visible=false

Question

Dear all,

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!!
Best regards

Answer 1

Nobody a clue?