Data Protection Issues

Can Administrators Disable Saved Passwords for Excel ODBC Connections?

Algirdas JasaitisAlgirdas Jasaitis Nov 22, 2026 868 views

Question details

An administrator wants to prevent standard users from saving database passwords in Excel ODBC connection settings across an organization.

Can Administrators Disable Saved Passwords for Excel ODBC Connections?
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.
Before you start

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.

Solution 1Recommended

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.

1
Review connection authentication

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.

2
Configure an approved authentication method

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.

3
Apply access controls

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.

4
Test the connection

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.

Control ODBC authentication through database and Windows policies
Check existing workbooks: Changing authentication policies does not automatically remove passwords already stored in workbooks or connection strings. Review affected connections and rotate credentials if exposure is suspected.
Free Microsoft Office alternative

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.

Open and edit spreadsheets in a familiar interfaceCompatible with Microsoft Excel formats such as XLSX and XLSUse a free, lightweight alternative for everyday Office workReview database-connected workbooks for compatibility before migration
microsoft office alternative - wps office

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.