PivotCache.CommandText property (Excel)

Returns or sets the command string for the specified data source. Read/write Variant.



expression An expression that returns a PivotCache object.


For OLE DB sources, the CommandType property describes the value of the CommandText property.

For ODBC sources, setting the CommandText property causes the data to be refreshed.

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.