Excel Performance Problems

How to Fix Excel 365 Linked Data Type Refresh Limit Errors

Steven ParkerSteven Parker Nov 4, 2026 868 views

Question details

The user is receiving a daily refresh limit exceeded error in an Excel 365 workbook containing 30 to 40 stock data types, despite the file being configured to only refresh upon opening.

How to Fix Excel 365 Linked Data Type Refresh Limit Errors
Product
Excel 365
Device & OS
not provided
Scenario
Attempting to track stock data using Excel's linked data types without triggering API request limits.
Observed behavior
Excel blocks further data updates and displays an error stating that the daily refresh limit has been exceeded due to background automatic refreshing.
Before you start

Ensure you have saved your current workbook progress locally and verify that your Microsoft 365 subscription is active, as data type services require a stable connection and a valid account.

Solution 1Recommended

Disable Background and Automatic Refresh for Data Connections

Turn off default automatic refresh settings to prevent Excel from silently making background requests that quickly exhaust your daily quota.

By default, Excel 365 linked data types may continuously poll servers for live updates. Disabling this allows you to manually control exactly when your 30-40 stocks retrieve new data, ensuring you stay well within Microsoft's daily limits.

1
Open Queries & Connections

Navigate to the 'Data' tab on the top Excel ribbon and click on 'Queries & Connections' to open the side panel.

2
Access Data Type Properties

In the panel, right-click on the specific Stock or Linked Data connection causing the issue and select 'Properties' from the context menu.

3
Disable Background Refresh

Go to the 'Usage' tab in the Properties window. Uncheck the box labeled 'Enable background refresh' and ensure that 'Refresh every X minutes' is also turned off.

4
Perform Manual Refreshes Only

Once the 24-hour restriction period naturally clears on your account, navigate to the 'Data' tab and click 'Refresh All' only when you explicitly need updated stock prices.

Disable Background and Automatic Refresh for Data Connections
Waiting Period Required: If you are currently seeing the limit error, changing the settings will not instantly restore access. You must wait for your daily quota to reset (typically up to 24 hours).
Free Microsoft Office alternative

Switch to WPS Office for a Lightweight Spreadsheet Experience

If you are tired of dealing with restrictive cloud API limits and complex background sync settings in Microsoft Excel 365, WPS Spreadsheet offers a highly capable, offline-friendly workspace for your financial data.

  1. 1. Download WPS Office: Visit the official WPS website and download the free version of WPS Office.
  2. 2. Open Your Spreadsheet: Launch WPS Spreadsheets and click 'Open' to select your existing .xlsx stock workbook.
  3. 3. Manage Data Without Limits: Use standard financial formulas or manual data inputs without worrying about hidden cloud refresh quotas.
Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv), ensuring seamless file transitions.Lightweight architecture that avoids unnecessary background cloud connections and unprompted data polling.Free to use with a familiar, tabbed interface that makes data management intuitive.Robust formula and charting support to manage your financial workbooks manually and reliably.
microsoft office alternative - wps office

Frequently Asked Questions

What exactly is the daily refresh limit for Excel linked data types?

Microsoft enforces an undisclosed daily quota on how many times external data types (like Stocks and Geography) can pull live information from third-party providers. This prevents server overload and API abuse.

How long does the Excel data refresh restriction last?

The refresh limit typically resets within 24 hours from the time the limit was triggered. You will not be able to fetch new linked data until this cooling-off period expires.

Why did my workbook hit the limit if I only opened it once?

If 'Enable background refresh' or 'Refresh every X minutes' is checked in your data connection properties, Excel silently continues to pull data from the server the entire time the file remains open, rapidly consuming your quota.