Excel VSTO pivot table code revision help needed...

[madforplaid]

Hello,

The first line below works cleanly in my project, but I am having
errors/issues with the next two lines.

Globals.Sheet16.PivotTables("PivotTable2").PivotCache.Refresh()
Globals.Sheet16.PivotTables("PivotTable2").PivotFields("fy").Item(1).Visibl­
e = True
Globals.Sheet16.PivotTables("PivotTable2").PivotFields("fy").Item(2).Visibl­
e = False

Please advise as to what is needed to revise the code to get it to
work as expected.

Thanks,

Kevin

 

[Herbert Seidenberg]

..PivotFields(1).PivotItems(2).Visibl­e = False

 

[Kevin]

Herbert,

Thanks, it worked as I had hoped!

Thanks,

Kevin

 

[madforplaid]

Herbert,

Thanks, it worked as I had hoped!

Thanks,

Kevin