How to Fix Excel STOCKHISTORY #CONNECT Error
Question details
The user is experiencing an issue where the STOCKHISTORY function intermittently fails, returning a #CONNECT error for certain ticker symbols while others load correctly.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Retrieving historical stock market data using the STOCKHISTORY formula in an Excel workbook.
- Observed behavior
- The formula works inconsistently, successfully retrieving data for some stocks but displaying a #CONNECT error for others, or behaving differently across different computers with the same file.
Ensure your device has a stable internet connection and that you are actively signed into your Microsoft 365 subscription, as the STOCKHISTORY function requires online access to Microsoft's financial data servers.
Verify Network Stability and Refresh the Workbook
Since STOCKHISTORY relies heavily on external cloud services, the most common fix is ensuring uninterrupted network access and forcing Excel to re-fetch the external data.
The #CONNECT error simply means Excel lost its connection to the external data provider (like Refinitiv). This can be caused by a momentary drop in your Wi-Fi, a firewall restriction, or a temporary outage on Microsoft's end.
Verify that your computer's Wi-Fi or ethernet connection is active and stable by loading a few web pages in your browser.
Open your affected Excel workbook, select the cell with the error, and press the F9 key on your keyboard to force Excel to recalculate all formulas and fetch fresh data.
If the error persists despite a strong network connection, wait 15 to 30 minutes and try again. Microsoft's financial data providers periodically experience temporary server outages.

Update Microsoft 365 and Verify Account Status
Outdated Excel versions or account synchronization issues can block access to premium online data types.
Check for Rate Limits and Unsupported Symbols
Pulling too much data rapidly or requesting unsupported stock symbols can trigger intermittent connectivity errors.
A Reliable Free Alternative for Everyday Spreadsheets
If you are frustrated by subscription requirements and external data errors in Microsoft Excel, consider switching to WPS Office. It provides a highly compatible, free, and lightweight solution for all your spreadsheet creation, editing, and data analysis needs.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install and Launch: Run the installer, follow the on-screen prompts, and open the WPS Spreadsheets application.
- 3. Open your files smoothly: Drag and drop your existing Excel (.xlsx) workbooks directly into WPS to continue your work without losing any formatting or local data.

Frequently Asked Questions
What exactly does the #CONNECT error mean in Excel?
The #CONNECT error indicates that Excel is unable to communicate with the external financial-data services provided by Microsoft. This is typically caused by a lack of internet connection, server outages, or corporate firewall restrictions blocking the data feed.
Can I use the STOCKHISTORY function while my computer is offline?
No. The STOCKHISTORY function requires an active internet connection to retrieve historical financial data from Microsoft's external service providers. Without internet access, it will return a #CONNECT or #BLOCKED error.
Why do some stock symbols work perfectly while others return a #CONNECT error?
This often happens if a specific financial exchange is experiencing data feed delays, or if the ticker symbol is no longer supported by the data provider. It can also occur if you are hitting API rate limits by pulling large amounts of historical data simultaneously.
Is STOCKHISTORY available in all versions of Microsoft Excel?
No, STOCKHISTORY is a premium connected data type only available to active Microsoft 365 subscribers. If you are using a standalone, perpetual license like Office 2019 or Office 2021, the function is not supported.




