Data Import & Export

How to Fix Excel External Data Refresh Failed Errors for Stock Quotes

John WilsonJohn Wilson Nov 2, 2026 869 views

Question details

Users encounter an 'External Data Refresh Failed' error when attempting to update workbooks that rely on linked data types, specifically stock quotes and financial fields.

How to Fix Excel External Data Refresh Failed Errors
Product
Microsoft Excel
Device & OS
not provided
Scenario
Refreshing workbook data linked to external providers, such as real-time stock market quotes.
Observed behavior
Excel displays an error message indicating the data refresh failed, which typically occurs because the underlying data service or specific data fields have been modified or deprecated by the provider.
Before you start

Ensure you have a stable internet connection and verify that your Office application is updated to the latest version, as updates occasionally restore data provider compatibility.

Solution 1Recommended

Isolate and Replace Deprecated Data Fields

Identify the specific data type or field causing the refresh failure and replace or remove it from your spreadsheet.

Data providers frequently update their services, which can result in certain fields (like Investment.Price or Change %) becoming unsupported. Isolating the broken field is the first step to restoring your workbook's functionality.

1
Open Queries & Connections

Navigate to the 'Data' tab on the Excel ribbon and click on 'Queries & Connections' to open the side pane. Review the status of your active data connections.

2
Test individual fields

Create a new, blank worksheet. Manually input your stock symbols and extract the data fields (e.g., Ticker Symbol, Price) one by one to determine exactly which field triggers the refresh error.

3
Remove or replace the broken field

Once the deprecated field is identified, delete all instances of it from your main workbook. If the provider offers a new equivalent field, add the new field to replace the deprecated one.

Isolate and Replace Deprecated Data Fields
Check Official Provider Updates: Review Microsoft's official documentation or the specific data provider's release notes to see a current list of supported data types and deprecated metrics.
Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Data Management

If Excel's external data connections and deprecated fields are disrupting your workflow, consider switching to WPS Office. It provides a highly compatible, free, and lightweight alternative for your spreadsheet management needs.

Highly compatible with Microsoft Excel (.xlsx, .xls) formats for seamless file transition.Free, lightweight, and fast-loading spreadsheet application without bloated background processes.Familiar user interface ensuring minimal learning curve for robust data analysis.Reliable built-in tools for advanced formula calculation and data visualization.
microsoft office alternative - wps office

Frequently Asked Questions

Why did my Excel stock data suddenly stop refreshing?

This generally happens when the external data provider (like Refinitiv or Microsoft's internal services) changes, deprecates, or removes specific fields that your workbook relies on, causing the entire refresh process to fail.

How do I find out exactly which field is causing the refresh error?

You can isolate the issue by creating a new blank worksheet and manually testing each data field (e.g., Ticker Symbol, Investment.Price, Change %) one at a time until the 'Refresh Failed' error reproduces.

Can I restore a discontinued Excel data feed?

No. If Microsoft or the third-party provider has officially discontinued the data feed or specific data types, it cannot be restored. Your best option is to remove the broken fields or migrate your workbook to a new, supported data source.