SaveData Property

Applies To

PivotTable Object.

Description

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

Example

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


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