SaveData Property

Applies To

PivotTable object, QueryTable object.

Description

True if data for the PivotTable is saved with the workbook. False if only the PivotTable definition is saved. Read/write Boolean.

Example

This example sets the PivotTable to save data with the workbook.

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