← Back to Error Directory

How to Fix #BUSY! Error in Excel

A rare error most people only ever see with real-time trading feeds or live data add-ins — here's what it means and when to actually worry.

Table of Contents

1. What #BUSY! Actually Means

#BUSY! is unlike almost every other error on this site because it isn't really a calculation failure — it's a live status message. It appears specifically when a formula calls the RTD() function (Real-Time Data), or a linked add-in that uses the RTD COM interface, and that external data source hasn't returned a value yet. Excel is telling you, in effect: "I asked, I'm waiting, I haven't given up."

Because of this, #BUSY! is one of the only error codes that's expected to disappear on its own within a second or two under normal conditions, replaced automatically by the actual live value once the external source responds.

2. Understanding RTD (Real-Time Data) Functions

RTD is a specialized Excel feature designed for streaming data — most commonly used with stock trading platforms, financial terminals (like Bloomberg or Reuters feeds), industrial SCADA systems, or custom COM-based add-ins that push continuously updating values into a spreadsheet. Unlike a normal formula that calculates once per recalculation cycle, an RTD-linked cell can update dozens of times per second as new data streams in from the external server.

=RTD("someserver.rtd",,"topic1","topic2")

The RTD server referenced in the first argument is a registered COM component running outside Excel — often installed alongside specialized financial or industrial software. If Excel calls this server and doesn't get an immediate response, it displays #BUSY! in the cell as a placeholder while it waits.

3. Interactive Demo: Simulated RTD Connection

This simulator mimics the timing behavior of a real RTD call — click connect and watch the state change from #BUSY! to a live value as the "server" responds.

Click to call the simulated RTD server

Increase the delay to 8000ms to feel what a slow or overloaded RTD server looks like from inside Excel — the cell would show #BUSY! the entire time.

4. The Three Root Causes of #BUSY!

Cause 1: Normal, brief initialization delay

The most common and completely harmless cause — when a workbook first opens or an RTD formula first calculates, there's a brief handshake period between Excel and the external COM server. This typically resolves within one to three seconds without any action needed.

Cause 2: The RTD server add-in is overloaded or slow

If the external data provider is under heavy load — common during high-volume trading hours for financial data feeds — response times can stretch to several seconds or longer, keeping #BUSY! visible for an extended period even though the connection is technically healthy.

Cause 3: The RTD server add-in has crashed, isn't installed, or lost its connection

If #BUSY! never resolves no matter how long you wait, the underlying COM server is likely not running at all, was never properly registered on your machine, or has lost its own connection to the ultimate data source (like a market data feed going offline).

5. When #BUSY! Is Temporary (Do Nothing)

If you've just opened the workbook, switched worksheets, or reconnected after a network interruption, give it 5-10 seconds before assuming there's a problem. Pressing F9 to force a recalculation can sometimes help nudge a stalled connection, but repeatedly forcing recalculation on a genuinely busy server can make things worse by adding more requests to an already-slow queue.

6. When #BUSY! Never Resolves

  1. Close and reopen the workbook — this fully reinitializes the COM connection to the RTD server rather than relying on a potentially stuck existing session.
  2. Check Windows Task Manager for the RTD server's background process (the exact process name depends on your specific add-in/provider) and confirm it's actually running.
  3. Verify network connectivity to the external data source, especially if it's a cloud-hosted or remote feed rather than a purely local add-in.
  4. Reinstall or update the RTD add-in if it hasn't been updated in a long time — provider-side API changes can silently break older versions.

7. Diagnosing the RTD Add-In Itself

Go to File → Options → Add-ins, then at the bottom change the "Manage" dropdown to COM Add-ins and click Go. Confirm your RTD provider's add-in is listed and checked. If it's missing entirely, it needs to be reinstalled from your data provider — Excel itself has no built-in RTD servers; every RTD connection depends entirely on a third-party add-in supplying the actual data.

8. Google Sheets Equivalent

Google Sheets does not use the RTD/COM architecture at all — it has no #BUSY! error. The closest equivalent behavior is GOOGLEFINANCE() occasionally showing #N/A briefly while a fresh query resolves, or a custom Apps Script function that hasn't finished executing yet showing "Loading..." momentarily. Neither behaves identically to Excel's RTD system, since Sheets' live-data functions are server-executed rather than relying on a locally installed COM add-in.

9. Best Practices for Live Data Workbooks

10. Frequently Asked Questions

What does #BUSY! mean in Excel?

#BUSY! appears when a real-time data (RTD) function or a live data add-in is still waiting for its external source to respond. It is typically a temporary state — Excel shows it while the connection is initializing, and it usually resolves automatically once the external server responds.

Is #BUSY! a permanent error?

Usually not. #BUSY! is a status indicator more than a true error — it means Excel is actively waiting on an external RTD server. If it never resolves after a reasonable wait, the underlying add-in or connection is the actual problem, not the formula itself.

How do I fix a #BUSY! error that never goes away?

Check that the RTD server add-in is properly installed and running, restart Excel to reinitialize the COM connection, and confirm the external data source (like a trading platform or live feed) is actually online and reachable from your network.

Can I use IFERROR to hide #BUSY! while waiting?

Yes, wrapping an RTD-dependent formula in IFERROR will display your fallback text during the brief #BUSY! window, and automatically switch to the live value once the server responds — this is a common pattern for cleaner-looking live dashboards.

Related Guides

Editorial Disclaimer: This guide is developed to the best of our domain knowledge and tested against Excel 2019+, Microsoft 365, and Google Sheets. Content is updated continuously as spreadsheet calculation engines evolve.