Forum Discussion
Stockhistory function is suddenly blocked
- 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.
Have found a fix which worked for me: Found it using Bing chat:
"If the STOCKHISTORY function is not working:
If you are using Office 365, try performing an Online Repair by right-clicking the Windows Start button, selecting “Apps and Features” on the pop-up menu, finding and clicking your Microsoft Office 365 application in the list, selecting Modify, then “Online Repair” and following the onscreen instructions."
This got rid of the error message and blocked STOCKHISTORY cells. Still one or two cells blank, but mostly working. Must be some major issues somewhere.
Hope this helps.
I tried something that seemed to work. Open the workbook that has the update. Save is as the same name with a-1 suffix. Close both worksheets. Open the original worksheet under old name.
it worked for me but I don't know if this is a permanent fix or just a one time fix.
- They are working on it, I think because I don't get the licensing error anymore, upon opening the spreadsheet.
Your method did not work here, though. Sadly.Look like MS fixed the problem. The function now works across all the workbooks. Stocks and exchange rates. The figures are also correct as of 10 Jul 2023 because I am in Asia. So I should wait a few more hours for the 11 Jul 23 data to work. For now I shall assume it is OK.
- It is already 12/7 in The Netherlands but the problem persists, sadly.
StockHistory function still broken on both web and regular versions of Excel, sadly.
