← Back to Error Directory

How to Fix #CONNECT! Error in Excel

When Excel loses its connection to a live data service — here's how to diagnose network, firewall, and account-level causes.

Table of Contents

1. What #CONNECT! Actually Means

#CONNECT! is a network-layer error, distinct from calculation errors like #VALUE! or #NUM! — it appears specifically when Excel's linked data types (Stocks, Geography) or certain live data connections cannot reach the external service they depend on. Where #FIELD! means "the connection worked but this field doesn't exist," #CONNECT! means "the connection itself failed before Excel could even ask the question."

2. Interactive Demo: Connection Diagnostic Flow

Walk through the same diagnostic logic Excel effectively performs internally when a linked data type formula fails to connect.

Uncheck "Firewall/proxy allows..." to see how a network policy block alone triggers #CONNECT!, independent of your general internet access.

3. The Five Root Causes of #CONNECT!

4. Network-Level Fixes

  1. Confirm general internet access by loading any website in a browser.
  2. Try refreshing the specific linked data cell (right-click → Data Type → Refresh) rather than the entire workbook, to isolate whether it's a workbook-wide or cell-specific issue.
  3. Temporarily disable VPN if one is active, then retry the connection.
  4. Restart Excel completely — this fully re-establishes any cached authentication tokens or connection state that might have gone stale.

5. Firewall & Proxy Configuration

If you're on a managed corporate or school network, #CONNECT! is very often a network policy issue rather than anything wrong with your formula or account. IT administrators may need to allowlist the Microsoft 365 service endpoints required for linked data types. This is a conversation for your IT/network administrator rather than something fixable from within Excel itself — if you suspect this is the cause, testing the same workbook on an unrestricted home network (not the managed one) is the fastest way to confirm it.

6. Microsoft Account & Licensing Issues

Certain linked data type features are tied to having an active, signed-in Microsoft 365 subscription rather than a one-time-purchase Excel license. Check File → Account within Excel to confirm you're signed in and that your subscription status shows as active. A lapsed subscription or a sign-in session that's silently expired can cause #CONNECT! even though everything else in Excel appears to work normally.

7. Checking for a Microsoft Service Outage

Before assuming the problem is on your end, check Microsoft's official service status page for Microsoft 365, since linked data types depend on backend services that occasionally experience their own downtime. If other people report the same issue at the same time, waiting it out is the only real fix — there's no local workaround for a genuine service-side outage.

8. Working Offline: Converting to Static Values

If you need the spreadsheet to remain usable without a live connection (for example, sharing a report with someone whose network blocks the required services), convert the linked data type cells to static values before distributing:

  1. Select the cells containing linked data types.
  2. Copy them (Ctrl+C).
  3. Paste Special → Values Only, in the same location or a new location.

This permanently disconnects the cells from the live service, freezing the last successfully retrieved values as plain data — appropriate for archival reports, but not suitable if you need the numbers to stay current.

9. Google Sheets Equivalent

Google Sheets does not use Excel's linked data type architecture, so there's no direct #CONNECT! equivalent. The closest parallel is IMPORTRANGE(), IMPORTDATA(), or GOOGLEFINANCE() failing with a generic error (often #N/A or "Error fetching data") when the underlying Google service or external URL is unreachable — the troubleshooting logic (check general connectivity, check for a service-side outage, check firewall/network restrictions) is functionally the same across both platforms.

10. Frequently Asked Questions

What causes the #CONNECT! error in Excel?

The #CONNECT! error appears when Excel cannot establish or maintain a connection to an external data source needed for a linked data type (like Stocks or Geography) or a live data feed. This is usually caused by lost internet connectivity, a Microsoft service outage, or a network firewall blocking the connection.

Does #CONNECT! mean my internet is down?

Not necessarily your entire internet connection, but it does mean Excel specifically cannot reach the data service it needs. This can happen even with a working general internet connection if a firewall, proxy, or VPN is blocking the specific Microsoft service endpoints Excel uses for linked data types.

Why does #CONNECT! only affect some cells and not others?

If only certain linked data type cells show #CONNECT! while others work, the issue is often intermittent connectivity or a temporary rate limit from Microsoft's data service, rather than a complete network failure — refreshing the affected cells individually can sometimes resolve it without restarting Excel.

Related Guides

Editorial Disclaimer: This guide is developed to the best of our domain knowledge and tested against Excel 2019+, Microsoft 365, and Google Sheets. Content is updated continuously as spreadsheet calculation engines evolve.