PivotCache.SavePassword Property (Excel)
True if password information in an ODBC connection string is saved with the specified query. False if the password is removed. Read/write Boolean .
expression A variable that represents a PivotCache object.
This property is used in both ODBC and OLEDB queries, and by both PivotTables and QueryTables.