TableStyle Property
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"