How to Fix Microsoft Query ODBC Error Too Many Client Tasks in Excel
Question details
The user needs to resolve an issue where Excel throws an ODBC error after exactly 64 data refreshes.

- 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.
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.
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.
Note your exact Microsoft Office version, Windows OS version, ODBC driver details, and the specific text of the error message.
Prepare a simplified, sanitized version of your Excel workbook that reliably replicates the crash after 64 refreshes.
Have your IT administrator log into the Microsoft 365 Admin Center.
Go to Support > New service request, describe the Microsoft Query ODBC connection limit, and attach your diagnostic files for the support engineering team.

Restart Excel to Clear ODBC Connection Pools
Use this temporary workaround to manually force the system to drop hanging background client tasks and reset the refresh counter.
Migrate from Microsoft Query to Power Query
Replace the outdated Microsoft Query technology with modern Power Query to eliminate legacy ODBC connection limitations entirely.
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. Download the Installer: Visit the official WPS Office website and click the free download button.
- 2. Install WPS Office: Run the downloaded setup file and follow the quick on-screen instructions.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing Excel files directly, with formatting perfectly preserved.

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.




