QueryTable.SaveData property (Excel)
True if data for the QueryTable report is saved with the workbook. False if only the report definition is saved. Read/write Boolean .
expression A variable that represents a QueryTable object.
For OLAP data sources, this property is always set to False .
If you import data using the object model, data from a Web query or a text query must be imported as a QueryTable , while all other external data can be imported as either a ListObject or a QueryTable .
You can use the QueryTable property of the ListObject to access the SaveData property.