Data Import & Export

How to Fix Excel Stock Data Daily Request Limit Exceeded

Emma BrownEmma Brown Nov 3, 2026 868 views

Question details

The user is experiencing a daily request limit exceeded error in Excel when trying to refresh linked stock data or when using the STOCKHISTORY function.

How to Fix Excel Stock Data Daily Request Limit Exceeded
Product
Microsoft Excel
Device & OS
not provided
Scenario
Updating or extracting the latest financial information for a large list of stocks (e.g., several hundred) using built-in Excel data types.
Observed behavior
Excel blocks further data extraction and displays a 'daily request limit exceeded' error message.
Before you start

Ensure you have saved your current workbook and note the time the error first appeared, as the API limit typically takes up to 24 hours to reset.

Solution 1Recommended

Wait for Reset and Optimize Data Refreshes

Since the API limit is enforced by Microsoft's data provider (Refinitiv) and cannot be bypassed, you must wait for the reset and adjust your workbook to reduce the number of queries.

Microsoft has not publicly published the exact daily request limit for stock data. Hitting this limit means your computer has made too many background API calls to Refinitiv in a 24-hour period. Waiting and optimizing your data list is the only resolution.

1
Wait 24 Hours

Pause all stock data updates in Excel and wait until the next day (approximately 24 hours) for your daily API request limit to reset.

2
Reduce the Number of Tracked Stocks

Review your list of stocks. If you are tracking several hundred stocks in a single workbook, consider splitting them into multiple files or removing tickers you do not actively need to track.

3
Minimize Manual Refreshes

Avoid clicking the 'Refresh All' button excessively. Only trigger a data update when you absolutely need the latest financial information, rather than continuously throughout the day.

Wait for Reset and Optimize Data Refreshes
Data Limit Enforcement: The daily limit applies to the local machine or Microsoft account. Creating a new workbook will not bypass the block until the 24-hour period has elapsed.
Free Microsoft Office alternative

Try WPS Office for Efficient Financial Spreadsheets

While stock data request limits are a strict restriction of Microsoft's specific data provider, WPS Office Spreadsheet offers a robust, free alternative for managing large financial datasets and complex statistical formulas without bloated background API calls slowing down your workflow.

Highly compatible with Microsoft Excel (.xlsx, .xls) formats, ensuring your financial models stay intact.Lightweight and fast, ideal for handling massive lists of financial data without lagging.Free alternative with a familiar user interface for a seamless, zero-learning-curve migration.
QA img-9

Frequently Asked Questions

What is the exact daily request limit for Excel stock data?

Microsoft has not publicly specified the exact number of requests allowed per day. However, users tracking large lists (such as 300 or more stocks) and refreshing frequently throughout the day often hit this limit.

How long do I have to wait after exceeding the Excel stock data limit?

The request limit resets daily. You will typically need to wait until the next calendar day, or up to 24 hours from when the error first appeared, to resume successfully refreshing your stock data.

Does the STOCKHISTORY function count toward the data limit?

Yes, every time a cell containing the STOCKHISTORY function calculates or updates, it sends a request to the Refinitiv server, which counts heavily against your daily API limit.

Can I bypass the stock data request limit in Excel?

No, the limit is strictly enforced by Microsoft's data provider. You cannot bypass it, but you can manage it by pasting unchanging historical data as static values and significantly reducing your refresh frequency.