Forum Discussion

Copper Contributor

Aug 01, 2021

Solved

Blocked from Using STOCKHISTORY Function Though Signed In

I'm using Microsoft Excel for MAC version 16.51 on a MacBook Pro 2020 with the M1 Chip. Have a Microsoft 365 Family account. When attempting to use the STOCKHISTORY function, I get an error mess...

Excel on Mac

Formulas and Functions

ExcelExciting
Aug 02, 2021
Hi Magic960

You are running into error because your are not signed into you Microsoft Office account, the STOCKHISTORY feature is exclusively available for subscription users.

If you are already a subscription user then make sure you are signed in into you account

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.

Suseelrao

Copper Contributor

Jul 02, 2023

ExcelExciting I have subscribed for office 365 yet "stockhistory" and such other functions are not active/enabled. how to get them enabled / activated for my use.

Thanks & Regards

Robert_Dougherty

Copper Contributor

Jul 11, 2023

ExcelExciting I have a similar problem. I have been using "stockhistory" for a long time, updating at the end of the day. Yesterday I started getting the message about needing to sign in from an account with a subscription. At the top of the Excel page it shows that I am signed in. We have an Office 365 family account. I have signed out and back in again but continue to get the same message. Is there somewhere else I need to sign in?

M_J_Palomo
Copper Contributor
Jul 11, 2023
After using the stockhistory function without a problem for more than a year I am now unable to update the stock price information. I am logged into my valid Microsoft account. The message I keep getting tells me to log in into an account I am already logged into. Help!!!
- Vega2677
  Copper Contributor
  Jul 11, 2023
  M_J_Palomo I had the #BLOCKED message yesterday too. Just restart your computer and sign in Excel with your user name and password; then, Stockhistory function will work again.
  Good luck!
  - Robert_Dougherty
    Copper Contributor
    Jul 12, 2023
    Vega2677 Thanks for well wishes. Turning off overnight and restarting in the morning did not change the situation. Logging out and logging back in did not change the situation. I don't have any information about whether it could be something my wife has or has not done on her system but she did report seeing a notification that there was a problem but she couldn't shut down at that moment to fix it. Perhaps tomorrow will make it all look trivial. Ha!