Forum Discussion
amit1601
Jul 11, 2023Brass Contributor
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...
- Jul 11, 2023No 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.
Scubski
Jul 11, 2023Copper Contributor
I contacted MS support yesterday on this issue - they investigated, but couldnt fix in Tier 1 support They told me they would escalate to Tier 2 support - I'm now awaiting their response.
Scubski
Jul 11, 2023Copper Contributor
I've just had a call back from MS Support: They are aware of the issue and have a team working on it - no estimate of when it will get fixed but as reported by another post on this forum, there was a similar issue in Feb which took ~4 days for MS to fix (so don't hold your breath for a speedy resolution to this!)
- TheSimArchitectJul 11, 2023Brass ContributorI can personally survive if it takes 4 days.
Otherwise it will be hell to replace the function with something else.
I hope it's something broken they'll fix and that they're not deprecating it without giving us enough time to at least convert the results from the formulas into values.
Otherwise I'll have tons of currency rate values to update manually. 🤪- MikuSippyJul 11, 2023Brass Contributor
TheSimArchitect
There is Google sheet and their equivalent function. But never liked Google version- TheSimArchitectJul 11, 2023Brass ContributorOh no. I have been using MS Excel since I moved from Lotus 123 back in the 90's. Please don't tell me I need to leave them after all this time. ðŸ˜
I also don't want to abandon Access. I am a bit scared to open my databases now.