TableStyle Property

Microsoft Excel Visual Basic

Returns or sets the style used in the body of the PivotTable report. The default value is a null string (no style is applied by default). Read/write String.

Remarks

This style is used as the default style for the background area, and it’s applied before any user formatting.

Example

This example sets the body of the PivotTable report to the PurpleAndGold style.

Worksheets(1).PivotTables("Pivot1").TableStyle = "PurpleAndGold"