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