Formula Errors

How to Fix Excel #NAME? Errors with Live External Data Feeds

Anum MushtaqAnum Mushtaq Oct 29, 2026 869 views

Question details

The user needs to resolve #NAME? errors that appear when trying to stream live stock market data from an external trading terminal into an Excel workbook.

How to Fix Excel #NAME? Errors with Live External Data Feeds
Product
Microsoft Excel
Device & OS
not provided
Scenario
Importing and continuously updating live stock market prices using an external data feed or trading terminal add-in, often involving OneDrive synchronization.
Observed behavior
Excel displays #NAME? errors in cells instead of live data because the necessary formulas, functions, add-ins, or external connections are unrecognized or unsupported in the current environment.
Before you start

Ensure that the computer opening the workbook has the required trading terminal software or data provider add-in installed and running locally.

Solution 1Recommended

Verify Trading Terminal Add-ins and Local Execution

OneDrive only synchronizes files; it does not process live data streams. The workbook must be opened in the desktop application with the necessary add-in active.

Live data feeds from trading terminals rely on local COM add-ins or software connections that cannot run through OneDrive or Excel for the Web. The host computer must actively process the data stream.

1
Open in Desktop Excel

Do not rely on Excel for the Web or OneDrive preview to update live prices. Open the workbook directly in the Excel desktop application.

2
Check Add-in Installation

Go to File > Options > Add-ins to verify that your trading terminal's data provider add-in is active and correctly configured.

3
Keep the Workbook Open

Leave the workbook open on a computer where the external connection and trading terminal are actively running to maintain the live data feed.

Verify Trading Terminal Add-ins and Local Execution
Continuous Updating: Uploading a file to OneDrive alone will not refresh live prices; the desktop application handles the actual data fetch.
Free Microsoft Office alternative

Looking for a Reliable and Lightweight Office Suite?

If you are troubleshooting complex add-in errors or performance issues with heavy spreadsheets in Microsoft Excel, consider trying WPS Office. It is a highly compatible, free, and lightweight alternative that handles your spreadsheet needs efficiently while providing a familiar interface.

  1. 1. Download WPS Office: Visit the official WPS website and download the free installation package.
  2. 2. Install the Software: Run the installer and follow the quick on-screen instructions to set up WPS Office on your device.
  3. 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files directly with full format compatibility.
Highly compatible with Microsoft Excel (.xlsx, .xls) formats and standard formulas.Free and lightweight, ensuring smooth performance even on older devices.Familiar user interface allows for seamless migration without any learning curve.Robust built-in data analysis tools to handle complex calculations and everyday tasks.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my live stock data show a #NAME? error only when viewed on OneDrive?

OneDrive is a file synchronization service, not a live data processor. It cannot execute local trading terminal add-ins or external COM connections. You must open the workbook in the desktop version of Excel where the add-in is installed to see the live data.

Can I fix the #NAME? error without reinstalling my trading add-in?

Yes, sometimes the error is caused by disabled privacy settings. Enabling 'Connected Experiences' via File > Account > Account Privacy > Manage Settings can restore access to external data services without needing to reinstall the add-in.

What causes a #NAME? error in Excel formulas generally?

The #NAME? error occurs when Excel cannot recognize text within a formula. This happens due to misspelled function names, missing quotation marks around text strings, or referencing a custom add-in function that is not currently loaded or supported.