Excel Error Codes

How to Fix Excel STOCKHISTORY #CONNECT Error

Huda QurayshiHuda Qurayshi Nov 10, 2026 869 views

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.

How to Fix Excel STOCKHISTORY #CONNECT Error
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.
Before you start

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.

Solution 1Recommended

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.

1
Check internet connectivity

Verify that your computer's Wi-Fi or ethernet connection is active and stable by loading a few web pages in your browser.

2
Force a manual recalculation

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.

3
Wait for service restoration

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.

Verify Network Stability and Refresh the Workbook
Data Provider Dependency: Excel does not store this financial data locally; it streams it on demand. Any disruption between your PC and the financial data servers will result in a #CONNECT error.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your operating system.
  2. 2. Install and Launch: Run the installer, follow the on-screen prompts, and open the WPS Spreadsheets application.
  3. 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.
100% compatible with Microsoft Excel (.xlsx) formatsLightweight installation with blazing fast performanceFree access to powerful spreadsheet formulas and charting toolsNo mandatory premium subscription for core spreadsheet functionsFamiliar user interface for seamless and quick migration
microsoft office alternative - wps office

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.