Copper Contributor

I bought a new laptop with pre-installed MS-office.  I signed in to my microsoft account on the new laptop and the Excel STOCKHISTORY function returns a 'BLOCKED' error.  I have checked my account privacy settings to allow connected experiences, but it isn't working anymore.  It is working fine on my old laptop with the same settings!  

5 Replies

@Anand1930 -Please do this !


  • Sign out from your o365
  • Reboot your machine.
  • Sign into o365 again.

This worked for me !

Thank you so much for your response. But that didn't fix it.
An additional note. On the new laptop, it is the Home and Student version. I no longer have access to the old 365 account since it was associated with work. Does STOCKHISTORY not work with the home and student version?


From Microsoft herself:

Important: The STOCKHISTORY function requires a Microsoft 365 Personal, Microsoft 365 Family, Microsoft 365 Business Standard, or Microsoft 365 Business Premium subscription.


@Detlef_Lewin Thanks!  I figured this out just as soon as I posted.