Data Import & Export

How to Fix Microsoft Query ODBC Error Too Many Client Tasks in Excel

Amos GikundaAmos Gikunda Oct 12, 2026 870 views

Question details

The user needs to resolve an issue where Excel throws an ODBC error after exactly 64 data refreshes.

How to Fix Microsoft Query ODBC Error Too Many Client Tasks in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
Refreshing external data connections to independent Excel files using the legacy Microsoft Query tool via ODBC.
Observed behavior
After approximately 64 consecutive data refreshes, the connection fails and displays a 'Too many client tasks' error message, indicating a hard limit or unreleased connection pool.
Before you start

Ensure you save a backup of your current workbook and verify that your system is running the most recent ODBC drivers for Excel before testing any new connection queries.

Solution 1Recommended

Escalate to Microsoft 365 Support for Diagnostic Investigation

Since this specific 64-refresh limitation is tied to deep Excel ODBC driver and connection-management mechanics, raising a support ticket is the most definitive way to secure a backend fix or authorized workaround.

The 'Too many client tasks' error is a known architectural limitation or memory leak symptom within the legacy Microsoft Query infrastructure. Background tasks fail to terminate properly after a refresh, eventually hitting a hardcoded system ceiling.

1
Collect System Diagnostics

Note your exact Microsoft Office version, Windows OS version, ODBC driver details, and the specific text of the error message.

2
Create a Reproducible Example

Prepare a simplified, sanitized version of your Excel workbook that reliably replicates the crash after 64 refreshes.

3
Navigate to the Admin Center

Have your IT administrator log into the Microsoft 365 Admin Center.

4
Submit a Service Request

Go to Support > New service request, describe the Microsoft Query ODBC connection limit, and attach your diagnostic files for the support engineering team.

Escalate to Microsoft 365 Support for Diagnostic Investigation
Administrator Privileges Required: Only users with Microsoft 365 Admin roles can submit and manage support tickets through the Admin Center.
Free Microsoft Office alternative

Try WPS Office for Seamless and Stable Data Management

If you are constantly battling legacy connection limitations, resource errors, or complex troubleshooting steps in Microsoft Excel, consider switching to WPS Office. It provides a highly compatible, lightweight, and modern alternative for managing your daily spreadsheet tasks without the heavy overhead.

  1. 1. Download the Installer: Visit the official WPS Office website and click the free download button.
  2. 2. Install WPS Office: Run the downloaded setup file and follow the quick on-screen instructions.
  3. 3. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing Excel files directly, with formatting perfectly preserved.
Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formatsOptimized memory handling for stable data processing and fewer system crashesLightweight installation with a familiar, easy-to-navigate user interfaceFree to use, reducing software licensing overhead
microsoft office alternative - wps office

Frequently Asked Questions

Why does the 'Too many client tasks' error happen exactly after 64 refreshes?

This occurs due to a hardcoded connection limit or a memory leak within the legacy Microsoft Query ODBC driver. The background tasks used to pull data do not properly terminate after a refresh, eventually maxing out the allowed client tasks ceiling.

How can I free up ODBC client tasks without restarting my computer?

You usually do not need to restart your entire computer. Saving your workbook and completely exiting the Microsoft Excel application will forcefully drop the hanging background connection tasks.

Is Microsoft Query being phased out in newer Excel versions?

While Microsoft Query is still accessible for backward compatibility, it is considered a legacy feature. Microsoft strongly recommends using the 'Get & Transform' (Power Query) feature for managing external data in modern versions.

Can I use Power Query to avoid this ODBC limit entirely?

Yes. Power Query uses a modernized engine for data connections and memory management. Rebuilding your data import using Power Query will generally bypass the legacy ODBC 'Too many client tasks' limitation.