Can Administrators Disable Saved Passwords for Excel ODBC Connections?
Question details
An administrator wants to prevent standard users from saving database passwords in Excel ODBC connection settings across an organization.

- Product
- Microsoft Excel ODBC connections
- Device & OS
- not provided
- Scenario
- The organization needs an enterprise-wide approach to controlling credentials used by Excel database connections.
- Observed behavior
- Excel offers a Save password checkbox for individual connections, but no confirmed global Office setting is available to disable it for every user.
Identify the ODBC drivers, databases, and authentication methods used by affected workbooks. Check whether each database and driver supports Windows integrated authentication or another approved passwordless method.
Control ODBC authentication through database and Windows policies
Use centrally managed authentication and access controls to reduce reliance on passwords saved in Excel workbooks.
There is no confirmed global Office setting that disables the Save password checkbox for all Excel users. Authentication and database policies can reduce credential exposure, but they do not necessarily remove the checkbox or prevent every form of password storage.
In Excel, open Data > Queries & Connections, open the connection properties, and check the Definition tab for the connection string and Save password setting. Menu names may vary by Excel version.
In the database administration tools and ODBC data source configuration, enable Windows integrated authentication or another centrally managed method supported by the database and driver.
In the database administration console, grant users only the permissions they need and restrict password-based authentication where supported and appropriate. Review applicable Windows and Group Policy credential settings with your security team; do not assume they disable Excel's checkbox.
Sign in as a standard user, open the workbook in Excel, and select Data > Refresh All. Confirm that the connection works with the approved authentication method and review the Definition tab for stored credentials.

Clear Save password for an individual Excel connection
Use this option to stop saving a password for a specific connection; it is not an enterprise-wide enforcement mechanism.
Edit Spreadsheet Files with WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface and support for Microsoft Office formats, making it easy to migrate everyday spreadsheet work. It does not enforce Excel's ODBC password settings; check connection compatibility before migrating database-connected workbooks.

Frequently Asked Questions
Is there a Group Policy that disables Excel's Save password checkbox for everyone?
No global Office setting that disables this checkbox for every user has been confirmed. Review applicable Windows credential policies, but use database authentication and access controls rather than assuming a policy removes the Excel option.
Where is Save password in Excel?
Open Data > Queries & Connections, open the relevant connection's properties, and look on the Definition tab. The available options and menu names can vary by Excel version and connection type.
Does clearing Save password remove every stored credential?
Do not assume it does. Review the connection string and any separately stored credentials, and check existing copies of the workbook for sensitive information.
Can Windows integrated authentication eliminate the need to save a database password?
It can avoid a separate database password in the connection when the database, ODBC driver, and organization support it. Configure and test the method with a standard user account before deployment.




