Data Import & Export

Fix Excel Linked Data Types Refresh and Offline Errors

Khadija KhanKhadija Khan Nov 11, 2026 868 views

Question details

The user is unable to refresh linked data types in Excel and receives an error prompting that Excel must be online.

How to Fix Excel Linked Data Types Refresh and Offline Errors
Product
Microsoft Excel
Device & OS
not provided
Scenario
Attempting to refresh linked data types (such as Stocks or Geography) in an existing Excel workbook.
Observed behavior
Excel displays a warning message stating it must be online to refresh linked data types, preventing the external data from synchronizing.
Before you start

Verify that your device has a stable internet connection, as linked data types require active network access to pull real-time information from external servers.

Solution 1Recommended

Verify Microsoft 365 Account and Connected Experiences

Ensure you are signed in to the correct Microsoft 365 subscription account and that online connected experiences are enabled in your Excel privacy settings.

Excel relies on Microsoft's cloud services to fetch data for linked data types. If your account session expires or privacy settings restrict online access, the refresh will fail.

1
Check Your Account

Open Excel and click on 'File' in the top-left corner, then select 'Account' from the left sidebar. Verify that you are signed in with the Microsoft 365 account associated with your active subscription.

2
Access Privacy Settings

Under the 'Account Privacy' section on the same page, click the 'Manage Settings' button.

3
Enable Connected Experiences

Scroll down to find 'Enable optional connected experiences'. Check this box to allow Excel to communicate with external data servers.

4
Restart Excel

Click 'OK' to save your settings. Close the Excel application entirely and reopen it for the changes to take effect.

Subscription Requirement: Premium linked data types such as Stocks and Geography require an active Microsoft 365 subscription to refresh. One-time purchase versions of Office (like Office 2019 or 2021) do not support this feature.
Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

If you frequently encounter connection errors, account sign-in loops, or subscription barriers with Microsoft 365, consider switching to WPS Office. It is a free, lightweight, and powerful alternative that offers excellent spreadsheet tools without strictly relying on background cloud services to function.

  1. 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite for your operating system.
  2. 2. Open Your Spreadsheet: Launch WPS Spreadsheets and select 'Open' to browse and load your existing Excel workbook.
  3. 3. Manage Data Without Interruptions: Enjoy editing, calculating, and analyzing your data smoothly with high compatibility.
Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv), ensuring no data loss when opening your files.Lightweight installation and low system resource usage for fast, offline data processing.Familiar spreadsheet interface that makes migration effortless with zero learning curve.Free to use for everyday data analysis and management, avoiding subscription-related interruptions.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel say it needs to be online when I am connected to Wi-Fi?

This error often occurs if Excel is blocked by your computer's firewall, if your Microsoft 365 login session has expired, or if 'Connected Experiences' are disabled in your Trust Center privacy settings, preventing Excel from reaching external data servers.

Do I need a Microsoft 365 subscription to use linked data types?

Yes, utilizing premium linked data types such as Stocks, Geography, and other dynamic data sources requires an active Microsoft 365 subscription to pull and refresh live data.

Can a formula error cause the offline linked data type error?

Usually, no. This specific offline error points to network connectivity, server availability, or account credential issues rather than an incorrect formula, macro, or function within your spreadsheet.

What should I do if the Refresh All button is greyed out?

If the 'Refresh All' button cannot be clicked, check if the workbook is in Protected View, if the specific worksheet is locked with a password, or if multiple sheets are grouped together. You must enable editing or unprotect the sheet before you can refresh external data.