Forum Discussion

asdfwee's avatar
asdfwee
Copper Contributor
Feb 03, 2022

How can I resolve #BLOCKED! error in Excel 2021 when using StockHistory function

Hello, I installed Excel 2021 today and specifically wanted to use the StockHistory function.  Frustratingly, when I attempt to lookup a stock it generates an error that says #BLOCKED!, and says that...
excel
JKPieterse's avatar
JKPieterse
Silver Contributor
Feb 04, 2022
I suspect a Microsoft 365 license is needed. From Help:
"STOCKHISTORY function
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web"
  • Loginy_hasa_dostpy's avatar
    Loginy_hasa_dostpy
    Copper Contributor
    Apr 15, 2022

    I have fully licensed package. It means nothing. Suddenly I got #BLOCKED and it's over. I may use the spreadsheet as a toilet paper. Woops, even as the toilet paper it's useless. Microsoft, you become more and more sorry-**bleep**.

Resources