Data Import & Export

How to Fix Excel ODBC Connection Stopped Working After Office Update

Camila MilosovichCamila Milosovich Nov 10, 2026 872 views

Question details

The user needs to restore an ODBC connection in Excel that stopped functioning immediately following a recent Office 365 update.

How to Fix Excel ODBC Connection Stopped Working After Office Update
Product
Microsoft Excel
Device & OS
not provided
Scenario
Attempting to query, import, or export data via an ODBC connection after Microsoft Office has been updated.
Observed behavior
The ODBC connection fails immediately when triggered in Excel, preventing any data operations from completing successfully.
Before you start

Verify that your ODBC credentials and data source name (DSN) are still valid by testing the connection outside of Excel using your system's ODBC Data Source Administrator tool.

Solution 1Recommended

Roll Back to a Previous Office Build

If a specific Office update (such as build 19426.20186) caused a product regression, reverting to an earlier stable version is the most effective workaround.

Microsoft release notes occasionally confirm that certain current-channel Office builds contain functional regressions. Rolling back your Office installation will restore the working ODBC environment until a permanent patch is deployed.

1
Disable Automatic Updates

Open Excel, navigate to File > Account > Update Options, and click 'Disable Updates' to prevent Office from immediately reinstalling the problematic build.

2
Open Command Prompt as Administrator

Search for 'cmd' in your Windows Start menu, right-click on the Command Prompt app, and select 'Run as administrator'.

3
Execute the Rollback Command

Navigate to the Office ClickToRun folder and run the 'OfficeC2RClient.exe /update user updatetoversion=' command appended with your desired stable build number.

Roll Back to a Previous Office Build
Report the Regression: To help Microsoft issue a fix, report the specific build failure by navigating to File > Account > Help Improve Office.
Free Microsoft Office alternative

Try WPS Office for Stable Data Management

Tired of disruptive Office updates breaking your critical data connections? WPS Office offers a stable, lightweight, and free alternative with exceptional compatibility for Microsoft Excel formats, ensuring your spreadsheet workflows remain uninterrupted.

  1. 1. Download and Install: Get the free WPS Office suite from the official website and install it on your computer.
  2. 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files directly without any formatting loss.
  3. 3. Resume Data Management: Continue analyzing and managing your data using a stable, familiar interface.
Highly compatible with Microsoft Excel (.xlsx, .xls) and CSV formatsStable environment free from disruptive background updatesFamiliar tabbed user interface for a seamless transitionLightweight architecture that consumes fewer system resources
microsoft office alternative - wps office

Frequently Asked Questions

Why did my ODBC connection suddenly stop working in Excel?

This typically happens when a background Microsoft Office update introduces a software regression, causes a mismatch in 32-bit/64-bit driver compatibility, or corrupts existing connection configurations. Specific builds, like 19426.20186, have been known to cause these regressions.

How do I find out which Office build I am currently using?

You can check your current build by opening Excel, clicking on 'File' in the top left corner, selecting 'Account', and looking under the 'About Excel' section for your version and build number.

Can I stop Office 365 from automatically updating and breaking my connections?

Yes. You can pause or disable automatic updates by opening Excel, navigating to File > Account, clicking on 'Update Options', and selecting 'Disable Updates'. This keeps you on a stable build until a reliable patch is released.