'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel STOCKHISTORY #BLOCKED Error
Question details
The user needs to understand why the STOCKHISTORY function is returning an error and determine which Microsoft Office licenses support retrieving historical stock data.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to retrieve historical stock data using the STOCKHISTORY function in Microsoft Excel.
- Observed behavior
- The STOCKHISTORY function fails and returns a #BLOCKED error instead of populating the spreadsheet with financial data.
Before troubleshooting, verify the exact version of Microsoft Office you are currently using, as the STOCKHISTORY function is heavily dependent on specific subscription licenses.
Verify Your Microsoft 365 Subscription Status
Check if you have an active Microsoft 365 subscription, as STOCKHISTORY is not supported on perpetual licenses like Office 2024 or Office 2021.
The STOCKHISTORY function is exclusively available to Microsoft 365 subscribers. If you recently purchased a perpetual license such as Microsoft Office Home 2024, this feature is restricted by design and will display a #BLOCKED error.
Launch Microsoft Excel, click on the "File" tab in the top-left corner, and select "Account" from the bottom of the left-hand menu.
Look under the "Product Information" section. Confirm whether your license is listed as "Subscription Product Microsoft 365".
If the product is listed as Office 2024 or another perpetual year-based version, the STOCKHISTORY function cannot be used on your current license.
Sign In with the Correct Microsoft Account
Ensure you are logged into Excel with the account tied to your active Microsoft 365 subscription.
Update Office to the Latest Version
Outdated software can sometimes cause connected data types like STOCKHISTORY to malfunction or fail to authenticate.
Use WPS Office as a Lightweight Alternative
If you are tired of dealing with expensive Microsoft 365 subscriptions just to avoid #BLOCKED errors, try WPS Office. It is a powerful, free, and highly compatible alternative for your daily spreadsheet, document, and presentation needs.
- 1. Visit the Official Website: Go to the official WPS Office website using your web browser.
- 2. Download the Installer: Click the 'Free Download' button to get the correct version for your Windows, Mac, or Linux operating system.
- 3. Install and Run: Open the downloaded file and follow the quick installation prompts to start using your new Office suite immediately.
Frequently Asked Questions
Why does Office 2024 not support the STOCKHISTORY function?
Microsoft restricts certain cloud-connected data types, including STOCKHISTORY, exclusively to Microsoft 365 subscription plans. Perpetual, one-time purchase licenses like Office 2024, 2021, or 2019 do not include these premium cloud features.
Can I fix the #BLOCKED error without a Microsoft 365 subscription?
No, if the error is caused by your license type, the only way to resolve it and use STOCKHISTORY natively is to upgrade to a qualifying Microsoft 365 subscription. As an alternative, you can manually export stock data from financial websites into CSV format.
What other errors might occur with the STOCKHISTORY function?
You might encounter #BUSY! if the data is still loading from the server, #VALUE! if the date parameters you entered are invalid, or #CONNECT! if you have lost your internet connection while Excel is trying to fetch the stock data.
