Excel Performance Problems

Fix Excel Out of Resources Error When Using STOCKHISTORY

Tauseeq Magsi Sep 25, 2026 869 views

Question details

The user experiences an intermittent out-of-resources error in Microsoft Excel when utilizing the STOCKHISTORY function to pull financial data.

Fixing the Excel Out of Resources Error When Using STOCKHISTORY

Product: Microsoft Excel
Device & OS: not provided
Scenario: Using the STOCKHISTORY function to retrieve dynamic financial and stock data within an Excel workbook.
Observed behavior: Excel displays an intermittent out-of-resources error, preventing the STOCKHISTORY function from calculating properly and potentially freezing the workbook.

Before you start

Ensure you have your workbook details, current Excel version, and a record of the specific STOCKHISTORY formulas causing the issue ready before reporting it to support.

Solution 1Recommended

Report the Error via Excel Feedback

Since this is a known intermittent bug with the STOCKHISTORY function, reporting your specific case helps developers track and patch the issue in future updates.

Microsoft actively monitors feedback for dynamic array functions like STOCKHISTORY. Providing exact error messages and formula parameters will help them diagnose the resource leak faster.

Open Excel Help

Navigate to the top ribbon menu in your Excel workbook and click on the 'Help' tab.

Access the Feedback Tool

Click on the 'Feedback' icon and then select 'Report a Problem' from the side pane.

Provide Issue Details

Describe the issue clearly. Include your Excel version, the exact STOCKHISTORY formula you used, and the text of the out-of-resources error message, then submit.

Community Workarounds: While waiting for a permanent fix, check Microsoft Excel community forums for current status updates and temporary user workarounds.

Solution 2

Update Microsoft Excel to the Latest Version

Microsoft frequently releases patches for known resource and memory bugs. Installing the latest update may resolve the STOCKHISTORY error.

Free Microsoft Office alternative

Try WPS Office for Stable Spreadsheet Performance

Tired of resource errors and memory crashes in Microsoft Excel? WPS Office is a free, lightweight, and highly compatible alternative that handles large datasets smoothly without draining your system resources.

1. Download and Install WPS Office: Visit the official WPS Office website and download the free version for your operating system.
2. Open WPS Spreadsheets: Launch WPS Spreadsheets from your desktop or start menu.
3. Open Your Excel File: Click 'Open' and select your .xlsx workbook to continue your work in a stable environment.

Highly compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Lightweight architecture prevents out-of-resources and memory crash errors.Familiar user interface ensures seamless and zero-cost migration.Built-in advanced data analysis and fast calculation engines.

microsoft office alternative - wps office

Frequently Asked Questions

Why does the STOCKHISTORY function cause Excel to run out of resources?

The STOCKHISTORY function retrieves dynamic array data from external financial servers. In certain Excel builds, rapid updates or large queries cause a temporary memory leak, leading to the out-of-resources error.

Is there a workaround for the STOCKHISTORY resource error?

While waiting for an official patch from Microsoft, you can try reducing the date range of your query, limiting the number of stock tickers checked at once, or manually refreshing the data instead of using volatile formulas.

Can I use STOCKHISTORY in older versions of Excel?

No, STOCKHISTORY is a dynamic array function available only to Microsoft 365 subscribers. Older standalone versions like Excel 2019 or 2016 do not support this feature.

Excel & Data Problems