Forum Discussion
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 associated with a subscription to user these data types. Select "sign in " at the top of excel. I am very well signed in , and can see that my office 365 family subscription is still alive. What am I missing here?
- 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.
79 Replies
I too have the same problem since 10th July 2023. STOCKHISTORY() shows #Blocked error message. I am a subscriber of MS Office 365 and I am always logged in while using Excel. Is there any alternate way to bring NSE Stock Historical Data into Excel in an automated way?
another one here... full 365 license.... I have 3 computers, =stockhistory is working on one....issue started yesterday 7/10..... pretty sure update ran on two problem computers...
thanks for the temp workaround, sending link from onedrive to email... that worked, not ideal but for now, OK
appreciate the sharing here
If you don't mind me asking. Same file and same account on all 3 computers? Could you tell us what's different between the good one and the lousy 2 ones?
- This function have had a few problems lately. At one time for 4 days there no updates to the stock data as well as exchange rates from 11 Feb 23 to 15 Feb 23. There will be blank or NIL data.
- MikuSippy I remember the four days of February...miserable.
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
- I just came to this forum to resolve the issue. Same problem. Is there a work around?
- Stocks function on Excel online is working.
- I'm having exactly the same issue. It works fine on Excel on my Macbook but it stopped working on my Windows machine on 10 July 2023. Nice to see that Apple is doing Windows better than Windows can...
- My goodness! Time for me to take the Late 2014 Macbook Pro out of the museum and use that instead. It is taking Microsoft too long to fix this. Ironic!!
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.
