Forum Discussion
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 ...
Copilot gave conflicting information; in one answer it said Excel 2021 supports it. I tried to make it work, but no success. Finally, I got this answer.
___________________________________________________________________________________________
does STOCKHISTORY function work in Excel 2021 (stand alone) on Windows 10 PC?
No, the STOCKHISTORY function does not work in Excel 2021 standalone on Mac. It requires a Microsoft 365 subscription to function properly.
Here’s what you need to know:
❌ STOCKHISTORY in Excel 2021 Standalone (Mac or Windows)
- Function visibility: STOCKHISTORY appears in Excel 2021’s formula library, so you can type it in and see syntax suggestions.
- Functionality blocked: When executed, it typically returns a #BLOCKED! error or a “License Required” message, because it relies on cloud-connected services that are exclusive to Microsoft 365.
- Platform parity: This limitation applies equally to Mac and Windows versions of Excel 2021. The issue is not OS-specific but license-specific.
✅ STOCKHISTORY Works With:
- Microsoft 365 subscription: Fully functional on both Mac and Windows when signed into a Microsoft 365 account.
- Excel for the Web: Also supports STOCKHISTORY if accessed via a Microsoft 365 subscription.
🔄 Why It’s Confusing
- Microsoft included STOCKHISTORY in Excel 2021’s formula set, but did not enable the backend data service for standalone users.
- This has led to frustration among users who assumed the function would work simply because it’s visible.