PivotTable.SaveData property (Excel)

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.