PageFieldStyle Property

Applies To

PivotTable object.

Description

Returns or sets the style used in the bound page field area. 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. Cells vacated when a field is pivoted from the page field area to another location retain this style.

Example

This example sets the page field area of the PivotTable to the PurpleAndGold style.

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