How to Fix Excel 365 Linked Data Type Refresh Limit Errors
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.

- 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.
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.
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.
Navigate to the 'Data' tab on the top Excel ribbon and click on 'Queries & Connections' to open the side panel.
In the panel, right-click on the specific Stock or Linked Data connection causing the issue and select 'Properties' from the context menu.
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.
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.

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. Download WPS Office: Visit the official WPS website and download the free version of WPS Office.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheets and click 'Open' to select your existing .xlsx stock workbook.
- 3. Manage Data Without Limits: Use standard financial formulas or manual data inputs without worrying about hidden cloud refresh quotas.

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.




