Forum Discussion
STOCKHISTORY function showing #BLOCKED
Oh no!! STOCKHISTORY gave us all so many problems in August 2024 that finally got cleared up. Now, today, the STOCKHISTORY function is showing #BLOCKED for all instances, all spreadsheets. The Alert suggests signing in to the 365 account. I was already signed in but signed out and then back in again. No change to #BLOCKED. Any suggested work arounds? IS this a sporadic fault or sol
The last report received for a STOCKHISTORY function was at 12:31pm EDT 10/21/24. Anything after that was #BLOCKED
On Excel for Mac 365
oops. it just started working again.. 10/21/2024 4:50pm
Same problem here. Tried signed out and back in and it still has the same problem.COULDN'T REFRESH DATA TYPES You need to sign in with an account associated with a subscription to use these data types.I also tried the online excel and it worked briefly before giving me the same error message too.
- I am having the same problem, Excel tech support was a waste of time. In the past when this has happened (maybe a year ago) it took a few days for Microsoft to fix the problem on their end, probably some database or server problem.
oops. it just started working again.. 10/21/2024 4:50pm
Same problem here. Tried signed out and back in and it still has the same problem.COULDN'T REFRESH DATA TYPES You need to sign in with an account associated with a subscription to use these data types.I also tried the online excel and it worked briefly before giving me the same error message too.Mine is still failing in the exact same manner
It broke again around 5 pm EDT Et1212
It appears that Microsoft has fixed the problem with excel populating STOCK data types now on the Mac platform. I checked under parallels running Microsoft 11 and the spreadsheet was fine, I then rebooted my Mac and opened Excel and it appears to be back to normal. Before reboot it was still corrupted.
ON a file that I had been using fine for a while, I just started getting the same #BLOCKED error using the STOCKHISTORY function on 11/05/24. The file had been working fine all last week. Have tried quitting EXCEL and have tried Rebooting my iMAC. I did sign into my MSN account, tried restarting Excel, but still get the same error.
No recent changes to the Excel File.
Have been running Sequoa 15.0.1 No recent updates.
Note This had happened many earlier this year and then self resolved. It acts like a server issue, posisbly MS or wherever MS get the stock info from.
What is going on?
