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.
TheSimArchitect
Jul 11, 2023Brass Contributor
It's not the SumProduct Formula being broken
Weirdly enough, if I open a cell, edit it (even to insert an error), then edit it back, it works.
TheSimArchitect
Jul 11, 2023Brass Contributor
Found a solution!
Open the spreadsheet broken.
Use, on your keyboard, Ctrl + Alt + F9
That forces excel to recalculate everything and fixes it. :fireworks::fireworks::fireworks:
Open the spreadsheet broken.
Use, on your keyboard, Ctrl + Alt + F9
That forces excel to recalculate everything and fixes it. :fireworks::fireworks::fireworks:
- TheSimArchitectJul 12, 2023Brass ContributorTry Ctrl + Alt + F9 on your keyboard with your spreadsheet open. That should force refresh it.
- marketbusinessJul 12, 2023Copper Contributormine is not working , there is no excuse for it not to work...it's basic retreiving of end of data quotes.
- MikuSippyJul 11, 2023Brass ContributorAh that is a good one, Recalculation! Many thanks, just really relieved things are back to normal. But of course, we know this function will have recurring problems, as noticed in the past.