Fix Excel Linked Data Types Refresh and Offline Errors
Question details
The user is unable to refresh linked data types in Excel and receives an error prompting that Excel must be online.

- 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.
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.
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.
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.
Under the 'Account Privacy' section on the same page, click the 'Manage Settings' button.
Scroll down to find 'Enable optional connected experiences'. Check this box to allow Excel to communicate with external data servers.
Click 'OK' to save your settings. Close the Excel application entirely and reopen it for the changes to take effect.
Restart Excel and Force Refresh
A simple application restart can often resolve temporary synchronization or session glitches preventing the data refresh.
Check Microsoft 365 Service Health
If the issue persists across multiple users or devices, the Microsoft linked-data service might be experiencing a temporary outage.
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. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite for your operating system.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheets and select 'Open' to browse and load your existing Excel workbook.
- 3. Manage Data Without Interruptions: Enjoy editing, calculating, and analyzing your data smoothly with high compatibility.

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.




