How to Fix Excel #NAME? Errors with Live External Data Feeds
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.

- 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.
Ensure that the computer opening the workbook has the required trading terminal software or data provider add-in installed and running locally.
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.
Do not rely on Excel for the Web or OneDrive preview to update live prices. Open the workbook directly in the Excel desktop application.
Go to File > Options > Add-ins to verify that your trading terminal's data provider add-in is active and correctly configured.
Leave the workbook open on a computer where the external connection and trading terminal are actively running to maintain the live data feed.

Enable Connected Experiences in Excel
Excel requires connected experiences to be enabled for certain external data features and cloud-based functions to work properly.
Check Formula Syntax and Version Compatibility
A #NAME? error often indicates that Excel does not recognize a function name or a named range provided by the external data feed.
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. Download WPS Office: Visit the official WPS website and download the free installation package.
- 2. Install the Software: Run the installer and follow the quick on-screen instructions to set up WPS Office on your device.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files directly with full format compatibility.

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.




