HasAutoFormat Property

Applies To

PivotTable object, QueryTable object.

Description

True if the PivotTable is automatically formatted when it's refreshed or when fields are moved. Read/write Boolean.

Example

This example causes the PivotTable to be automatically reformatted when it's refreshed or when fields are moved.

Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
pvtTable.HasAutoFormat = True