Forum Discussion

mloh28's avatar
mloh28
Copper Contributor
Mar 22, 2025

Stockhistory returning #BLOCKED! error

I started getting this error a couple of days ago. Summary of the problem and what Excel Tech Support did but didn't fix the problem. 1. I get #BLOCKED! error with my stockhistory formula but stock ...
BI & Data Analysis
excel
Excel for web
Formulas and Functions
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Mar 29, 2025

The STOCKHISTORY function is exclusive to Microsoft 365 subscribers and isn't available in standalone versions like Excel 2021. Users with perpetual licenses have reported encountering the #BLOCKED! error when attempting to use this function.

If you're connected to a corporate network, firewall or proxy settings might block Excel's access to online data sources, leading to the #BLOCKED! error. Consult your IT department to verify network configurations.

While the STOCKHISTORY function is available in Excel for the Web, ensure you're using a supported browser and that your Microsoft 365 subscription is active.​

The disappearance of the Data Types group and related icons suggests a customization or installation issue. Since reinstating the group and reinstalling Office didn't resolve the problem, it might be linked to licensing or network restrictions.

I hope this helps...but if it doesn't, I recommend providing more information about the digital environment. Information like the Excel version, operating system, storage medium (OneDrive, SharePoint, hard drive, etc.).

Otherwise, I wish you the best of luck.

Resources