Applies To
PivotTable Object.
Description
True if the PivotTable is automatically formatted when it is refreshed or when fields are moved. Read-write.
Example
This example causes the PivotTable to be automatically reformatted when it is refreshed or when fields are moved.
Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
pvtTable.HasAutoFormat = True