PivotCache.RobustConnect procedure builder

PivotCache.RobustConnect (Excel)

Returns or sets how the PivotTable cache connects to its data source.

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