Fix Excel 2016 Crashes During ODBC Queries After an Office Update
Question details
Investigate Excel 2016 crashes during customized enterprise reports that use ODBC queries.

- Product
- Microsoft Excel 2016
- Device & OS
- not provided
- Scenario
- A workbook uses VBA to copy dynamically generated SQL into a query table and run an ODBC report.
- Observed behavior
- Excel crashes when server results begin returning on version 1803, build 9126.2259. The same reports work on version 1708.
In Excel, open File > Account to record the Office version and build. Identify the ODBC driver, the query parameters, and the VBA procedure used to run the report so you can compare affected and working installations.
Test the ODBC report with an updated Office build and driver
Use this approach to investigate whether a later Office build or ODBC driver resolves the compatibility issue.
Document the exact SQL query, parameters, driver version, workbook VBA process, and crash details before changing the test environment. Remove sensitive data before sharing diagnostic information.
Office 2016 is out of support. Plan a move to a supported Office version and verify that the report and driver work with it.
In Excel, select File > Account and record the version and build under Product Information. Compare it with a working version 1708 installation.
Open the operating system's ODBC data source administrator and inspect the data source and driver used by the report. Record the driver name, version, and whether it matches the Excel installation's 32-bit or 64-bit architecture.
In Excel, select File > Account > Update Options > Update Now if updates are available and your organization permits them. Obtain a compatible ODBC driver update from the driver vendor or your IT team.
Run the same report with the same parameters and note when Excel closes, any error message, and whether results had started returning. Provide those details and the VBA process to your IT or support team.

Temporarily roll back affected Excel installations to version 1708
Use the previously working version as a temporary workaround while the version 1803 compatibility issue is investigated.
Work with spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface and support for common Microsoft Office formats, making it easy to move everyday documents and spreadsheets. It does not fix the Excel ODBC crash; test enterprise queries and VBA workflows separately before migrating.

Frequently Asked Questions
Why does Excel crash when the ODBC results start returning?
The reported timing suggests a compatibility issue involving the Office build, ODBC driver, or workbook query process, but it does not establish a specific cause. Compare the driver and Office versions on working and affected installations, then test updates.
How can I check my Excel version and build?
Open Excel and select File > Account. Look under Product Information for the Office version and build, then compare them with the affected version 1803 build and the working version 1708 installation.
What information should I give my IT team?
Provide the SQL query and parameters, ODBC driver name and version, workbook VBA steps, Office version and build, crash timing, and any error message. Remove sensitive information before sharing.
Will rolling back to version 1708 permanently fix the issue?
Version 1708 is a reported temporary workaround, not a confirmed permanent fix. Ask IT to manage the rollback through the organization's deployment process and investigate a supported long-term configuration.
Can WPS Office fix the Excel ODBC crash?
No. WPS Office is an alternative for working with compatible spreadsheet files, but it does not repair Microsoft Excel. Test any required ODBC connections and VBA workflows separately before switching.




