Office Apps Crashing

Fix Excel 2016 Crashes During ODBC Queries After an Office Update

Algirdas JasaitisAlgirdas Jasaitis Nov 20, 2026 869 views

Question details

Investigate Excel 2016 crashes during customized enterprise reports that use ODBC queries.

Fix Excel 2016 Crashes During ODBC Queries After an Office Update
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.
Before you start

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.

Solution 1Recommended

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.

1
Record the Office build

In Excel, select File > Account and record the version and build under Product Information. Compare it with a working version 1708 installation.

2
Identify the ODBC driver

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.

3
Check available updates

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.

4
Reproduce and document the crash

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.

Test the ODBC report with an updated Office build and driver
Update controls may be managed: Update Options can be unavailable or controlled by organizational policy. Ask your IT team to deploy an approved test build if needed.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for everyday reportingWork with Word and PowerPoint formats alongside spreadsheetsFree, lightweight suite for common office tasks
microsoft office alternative - wps office

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.