[Required/Optional] Optional [Data Type] Variant [Description] A string that contains ODBC settings that allow Excel to connect to an ODBC data source. The connection string has the form "ODBC;". This argument overrides any previous setting for the PivotCache object’s Connection property. [Name] 
Connection