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