PivotCache.RobustConnect (Excel)

Returns or sets how the PivotTable cache connects to its data source. Possible return values are xlAlways - The PivotTable cache or query table always uses external source information (as defined by the SourceConnectionFile or SourceDataFile property) to reconnect, xlAsRequired - The PivotTable cache or query table uses external source information to reconnect by using the Connection property, xlNever - The PivotTable cache or query table never uses source information to reconnect.

ActiveWorkbook.PivotCaches(1).RobustConnect = xlAlways