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.
Not everyone may want to store their files in OneDrive and that is a workaround. I prefer to keep my files in the local PC. Never liked to use OD though.
The OneDrive trick does not work for me. My file was already on OneDrive.
I still get the #Value error even using my browser (no "You need to sign in with a subscription account to use these data types. Select Excel from the top menu and then select Sign In." error on the web version of Excel, though.
Reinstalling Office (per MS Support instructions) does not fix it either but it changed the #Blocked for #Value. The "You need to sign in with a subscription account to use these data types. Select Excel from the top menu and then select Sign In." still shows up.
Diagnosing the entire formula shows the issue is indeed with the StockHistory function. Other functions work normally.
- just a guess, but maybe you have not logged into your onedrive account through browser. Try to login first and then try opening file into browser through your onedrive account.
