Forum Discussion

Magic960's avatar
Magic960
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's avatar
    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.

Robert_Dougherty's avatar
Robert_Dougherty
Copper Contributor
Jul 11, 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!

Robert_Dougherty's avatar
Robert_Dougherty
Copper Contributor
Jul 16, 2023
It took a couple more days before the function began to work as it historically had worked. To our our knowledge we did nothing on our end that changed anything.

Resources