PivotTable.TableStyle2 Property (Excel)

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

Version Information

Version Added: Excel 2007

Syntax

expression .TableStyle2

expression A variable that represents a PivotTable object.

Remarks

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

Example

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

See Also

Concepts

PivotTable Object

PivotTable Object Members