PivotCache.QueryType property (Excel)

  • Article

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

Syntax

expression.QueryType

expression A variable that represents a PivotCache object.

Remarks

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.