SaveData Property

Microsoft Excel Visual Basic

previous page next page

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

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
previous page start next page