Forum Discussion
STOCKHISTORY and #BLOCKED error
Hi,
I'm trying to use STOCKHISTORY function in excel, but I'm always getting #BLOCKED error.
I'm not really sure what is the cause of this error.
I'm only using the free online Excel version. Perhaps I need to upgrade to Premium to have this function?
Thanks
8 Replies
Lau11My understanding is that the function is only available to Microsoft 365 subscribers, and on beta channel. I signed up as MS Insider and have been using/testing it for a week now.
https://techcommunity.microsoft.com/t5/excel-blog/announcing-stockhistory/ba-p/1404338
doktorj , it's available in Excel Online, but doesn't work properly (so far).
SergeiBaklan thanks for this information. I am a microsoft 365 subscriber but only have access to online 365. Up until a few days okay the stockhistory function did not appear on my excel online. It did today but then I get the blocked messsage when trying to retrieve stock data. Anyone from Microsoft that can support with this?
Interesting. I repeated it, the same error
Have no idea what it means under "License required", this function works on my desktop installation (beta channel). Will try to investigate more.
But STOCKHISTORY works on my MacBook Air, simple subscription to Microsoft 365......hmmm
Yes, it works on desktop application, but appeared only recently for Excel Online and I'm not sure what the is the problem here.
- Yes. STOCKHISTORY is not available in the free online version. https://support.microsoft.com/en-us/office/stockhistory-function-1ac8b5b3-5f62-4d94-8ab8-7504ec7239a8
