[Name] Connection [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.