Forum Discussion

DanielPTax's avatar
DanielPTax
Copper Contributor
Dec 08, 2022

Stockhistory has started showing #BLOCKED even though I am signed in to an appropriate subscription

My stockhistory formulas have started showing #BLOCKED even though I am signed into an appropriate account with a subscription.  The banner at the top is "COULDN'T REFRESH DATA TYPES" You need to sign in with an account associated with a subscription to use these data types.  Select "Sign in" at the top of excel.  They worked before and just stopped working.  I have confirmed the subscription info and it is for Office 365.  I have signed in out and back in and restarted windows 11 (which has had its own bugs).  There does not appear to be a good way to troubleshoot this to determine if it is some local issue or a Microsoft server-side issue. 

 

Any suggestions?

Formulas and Functions
  • DanielPTax's avatar
    DanielPTax
    Copper Contributor
    Dec 08, 2022
    As of 12/8/2 12:21 PST it was working again. Just as mysteriously as it stopped working
  • jamesrazook's avatar
    jamesrazook
    Copper Contributor
    Dec 08, 2022

    DanielPTax The exact same thing happened to me. I've used it almost every day for a year. Today I opened my spreadsheet and =STOCKHISTORY shows #BLOCKED!

     

    Please Help!

Resources