Forum Discussion

amit1601's avatar
amit1601
Brass Contributor
Jul 11, 2023
Solved

Stockhistory function is suddenly blocked

I have been a subscriber of office 365 and regular user of stockhistory function in excel for past 3 years. Today , all of sudden, my excel shows me error that I need to  sign in with an account asso...
Formulas and Functions
  • amit1601's avatar
    amit1601
    Jul 11, 2023
    No update on how and when it will be resolved. But I've a work around that you can do - save the excel in one drive and then using the one drive URL of excel open it on a browser. It will work fine.
MikuSippy's avatar
MikuSippy
Brass Contributor
Jul 11, 2023

amit1601I too have experienced this problem today. Would you happen to have the latest update when this will be resolved? I m so surprised about this issue cropping up on my valid paid subscription to Office 365.

amit1601's avatar
amit1601
Brass Contributor
Jul 11, 2023
No update on how and when it will be resolved. But I've a work around that you can do - save the excel in one drive and then using the one drive URL of excel open it on a browser. It will work fine.
  • JerryDNYC's avatar
    JerryDNYC
    Copper Contributor
    Jul 11, 2023
    This is a great work around unless your data sources are CSV files pulled in with Power Query! 🤪
    • MikuSippy's avatar
      MikuSippy
      Brass Contributor
      Jul 11, 2023

      JerryDNYC 

       

      Not everyone may want to store their files in OneDrive and that is a workaround. I prefer to keep my files in the local PC. Never liked to use OD though.

      • TheSimArchitect's avatar
        TheSimArchitect
        Brass Contributor
        Jul 11, 2023

        MikuSippy 

         

        The OneDrive trick does not work for me. My file was already on OneDrive.

         

        I still get the #Value error even using my browser (no "You need to sign in with a subscription account to use these data types. Select Excel from the top menu and then select Sign In." error on the web version of Excel, though.

         

        Reinstalling Office (per MS Support instructions) does not fix it either but it changed the #Blocked for #Value. The "You need to sign in with a subscription account to use these data types. Select Excel from the top menu and then select Sign In." still shows up.

         

        Diagnosing the entire formula shows the issue is indeed with the StockHistory function. Other functions work normally.

         

         

  • Scubski's avatar
    Scubski
    Copper Contributor
    Jul 11, 2023

    amit1601 

    I had the same issue - but the workaround (access onedrive via browser) seems to work - thanks!

     

  • lintzac's avatar
    lintzac
    Copper Contributor
    Jul 11, 2023

    Thanks MikuSippy ! Using the browser for now. The problem started following the windows update I did on Sunday, 9th of July.

    • MikuSippy's avatar
      MikuSippy
      Brass Contributor
      Jul 11, 2023
      That gave me a clue on couple of things. Did an update as well, and then there was a prompt about the updating of NordVPN change of network. Let me check on this one.
      • MikuSippy's avatar
        MikuSippy
        Brass Contributor
        Jul 11, 2023
        NordVPN network adapter is not the issue.

        Neither was the last update yesterday: June 13, 2023-KB5027538 Cumulative Update for .NET Framework 3.5, 4.8 and 4.8.1 for Windows 10 Version 22H2

        So I am guessing there is something else. Not many people seem to report this kind of problem. How do we know that MS Support is aware of this problem, this need to be fixed urgently. Surely many other entities are also facing this problem.
  • MikuSippy's avatar
    MikuSippy
    Brass Contributor
    Jul 11, 2023
    Thank you for the prompt answer Amit. So Onedrive need to be used as a temp workaround.
    I am so reluctant to use onedrive or anything relating to the cloud. Not comfortable to save the content there. Maybe I have to wait.

Resources