Forum Discussion
Blocked Error in excel using function =stockhistory
I am not entirely sure what is going on here. I am signed in, it was working yesterday, but is no longer working and the sheet was never touched. I am on Mac, but I have gone between my PC and my Mac (ARM chip) without issues for weeks and this is the first time I am seeing the error.
1 Reply
I had this error - happened multiple times and I fix the problem by deleting contents of the cell and then restore contents with CTRL-Z. Today I found an update Office 365 button under Account settings. Kinda surprised Office 365 was not updating automatically and actually it took 4 or 5 minutes to complete the update. I suppose it was not a minor update especially if I was supposed to be doing that for the last 4 years! After I restarted Excel, all the #BLOCKED messages are gone.
Not sure if this will last but for now its working.
