Collapse the table of content
Expand the table of content
Expand Minimize
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

PivotTable.TableStyle2 Property (Excel)

The TableStyle2 property specifies the PivotTable style currently applied to the PivotTable. Read/write.

Version Added: Excel 2007

expression .TableStyle2

expression A variable that represents a PivotTable object.

The property is called TableStyle2 because there is an exisiting property named TableStyle.

Sub ApplyingStyle() 
 ActiveSheet.PivotTables("PivotTable1").TableStyle2 = "PivotStyleLight17" 
End Sub 

© 2016 Microsoft