Forum Discussion

Copper Contributor

Dec 27, 2020

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. P...

excel

Excel for web

Formulas and Functions

office 365

doktorj

Copper Contributor

Jan 02, 2021

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

SergeiBaklan

Diamond Contributor

Jan 02, 2021

doktorj , it's available in Excel Online, but doesn't work properly (so far).

paulkelly
Copper Contributor
Mar 08, 2021
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?
- JMCORONATI1
  Copper Contributor
  Mar 08, 2021
  paulkelly
  Using office 365 ProPlus excel, stockhistory when entered shows #BLOCKED! error, not sure why - my license is running on other computers, our license allows for each person to lost office on 5 devices. This is a business account - works on 1 of my laptop(1) and not on my other laptop(2).
  Note: laptop(1) - windows 10
  laptop(2) - windows 7 Professional
  
  Any help is appreciated - thanks.