STOCKHISTORY and #BLOCKED error

%3CLINGO-SUB%20id%3D%22lingo-sub-2016458%22%20slang%3D%22en-US%22%3ESTOCKHISTORY%20and%20%23BLOCKED%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2016458%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20use%20STOCKHISTORY%20function%20in%20excel%2C%20but%20I'm%20always%20getting%20%23BLOCKED%20error.%3C%2FP%3E%3CP%3EI'm%20not%20really%20sure%20what%20is%20the%20cause%20of%20this%20error.%3C%2FP%3E%3CP%3EI'm%20only%20using%20the%20free%20online%20Excel%20version.%20Perhaps%20I%20need%20to%20upgrade%20to%20Premium%20to%20have%20this%20function%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2016458%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2017011%22%20slang%3D%22en-US%22%3ERe%3A%20STOCKHISTORY%20and%20%23BLOCKED%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2017011%22%20slang%3D%22en-US%22%3EYes.%20STOCKHISTORY%20is%20not%20available%20in%20the%20free%20online%20version.%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fstockhistory-function-1ac8b5b3-5f62-4d94-8ab8-7504ec7239a8%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fstockhistory-function-1ac8b5b3-5f62-4d94-8ab8-7504ec7239a8%3C%2FA%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2017688%22%20slang%3D%22en-US%22%3ERe%3A%20STOCKHISTORY%20and%20%23BLOCKED%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2017688%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F912113%22%20target%3D%22_blank%22%3E%40Lau11%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EInteresting.%20I%20repeated%20it%2C%20the%20same%20error%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20401px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F243056i6EEC142DA76987B8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EHave%20no%20idea%20what%20it%20means%20under%20%22License%20required%22%2C%20this%20function%20works%20on%20my%20desktop%20installation%20(beta%20channel).%20Will%20try%20to%20investigate%20more.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2017884%22%20slang%3D%22en-US%22%3ERe%3A%20STOCKHISTORY%20and%20%23BLOCKED%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2017884%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20STOCKHISTORY%20works%20on%20my%20MacBook%20Air%2C%20simple%20subscription%20to%20Microsoft%20365......hmmm%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

@Lau11 

Interesting. I repeated it, the same error

image.png

Have no idea what it means under "License required", this function works on my desktop installation (beta channel). Will try to investigate more.

@Sergei Baklan 

 

But STOCKHISTORY works on my MacBook Air, simple subscription to Microsoft 365......hmmm

@mathetes 

Yes, it works on desktop application, but appeared only recently for Excel Online and I'm not sure what the is the problem here.

@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).

@Sergei Baklan 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?

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