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
S
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.

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
		




Show:
© 2015 Microsoft