Forum Discussion

Lau11's avatar
Lau11
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
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 02, 2021

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

paulkelly's avatar
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's avatar
    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. 

     

Resources