Forum Discussion

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

Jmnichols22

Copper Contributor

Jul 11, 2023

amit1601

I have exactly same issue on two of my laptops just started today, but it works on my desktop. All have latest build of 365 however if I place the file on OneDrive and share link though email I can open file from email and stocks refresh works on my laptops. This appears to be some new office bug associated with networking but I cannot resolve it

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
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
  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
    Copper Contributor
    Jul 11, 2023
    This is a great work around unless your data sources are CSV files pulled in with Power Query! 🤪