Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

SaveData Property [Excel 2003 VBA Language Reference]

Office 2003

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


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


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

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

© 2015 Microsoft