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.
amit1601's avatar
amit1601
Brass Contributor
Jul 11, 2023

thanks Jmnichols22 . That's some solace that it's a bug and would be fixed(hopefully) soon. I was worried with such sudden development and it's not easy to get support in matter regarding Windows.

Thanks for your prompt suggestions.

 

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.

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

Resources