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
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.
coolhand1517's avatar
coolhand1517
Copper Contributor
Jul 11, 2023
MikuSippy I remember the four days of February...miserable.
  • MikuSippy's avatar
    MikuSippy
    Brass Contributor
    Jul 11, 2023
    OH YES! Horrible, the immense pressure to deliver the work and the hand-wringing times to find an alternative solution(s).

Resources