How to Fix Excel Stock Data Daily Request Limit Exceeded
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.

- 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.
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.
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.
Pause all stock data updates in Excel and wait until the next day (approximately 24 hours) for your daily API request limit to reset.
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.
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.

Convert Historical Formulas to Static Values
Prevent Excel from constantly pinging the server for old data by converting your dynamic STOCKHISTORY formulas into plain text values.
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.

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.




