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.
Syntax
expression .SavePassword
expression A variable that represents a PivotCache object.
Remarks
This property is used in both ODBC and OLEDB queries, and by both PivotTables and QueryTables.