Forum Discussion
STOCKHISTORY function showing #BLOCKED
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.
oops. it just started working again.. 10/21/2024 4:50pm
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?
It broke again around 5 pm EDT Et1212
Mine is still failing in the exact same manner
