Specifies how the PivotTable cache connects to its data source.

Version Information
Version Added: Excel

Name Value Description
xlAlways 1 The cache always uses external source information (as defined by the SourceConnectionFile or SourceDataFile property) to reconnect.
xlAsRequired 0 The cache uses external source information to reconnect using the Connection property.
xlNever 2 The cache never uses source information to reconnect.