PivotCache.QueryType property (Excel)

Indicates the type of query used by Microsoft Excel to populate the PivotTable cache. Read-only XlQueryType.



expression A variable that represents a PivotCache object.


You specify the data source in the prefix for the Connection property's value.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.