PreserveFormatting Property

Applies To

PivotTable object.

Description

True if PivotTable formatting is preserved when the PivotTable is refreshed or recalculated by operations such as pivoting, sorting, or changing page field items. Read/write Boolean.

Example

This example causes the PivotTable to preserve formatting.

Worksheets(1).PivotTables("Pivot1").PreserveFormatting = True