PivotTable.SaveData Property

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

Syntax

expression.SaveData

expression A variable that represents a PivotTable object.

Remarks

For OLAP data sources, this property is always set to False.

Example

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

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

See also:

• PivotTable Object
• PivotTable Object Members