How to Fix Excel External Data Refresh Failed Errors for Stock Quotes
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.

- 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.
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.
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.
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.
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.
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.

Migrate to a Supported Data Source
If the original external data feed has been completely discontinued, transition your workbook to a new, reliable data source.
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.

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.




