Aug 01 2021 12:07 PM
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 message
"not signed in". What fixes this problem?
Thanks,
Timothy Sharp
Aug 02 2021 01:48 PM
SolutionHi @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.
Aug 03 2021 04:00 AM
Aug 08 2021 03:18 AM
Feb 10 2023 09:11 PM
@Faraz Shaikh I recently purchased a subscription for Windows 11 MS Office Professional Plus and I am clearly signed in and have added the add in - yet my first attempt using an older spreadsheet that was on my older pc - its set of basic stockhistory function calls shows #BLOCKED! The triangle icon shows 'license is required'. I tried with a new workbook as well - shows same deal. What do I need to do next?
Feb 10 2023 09:14 PM
Jul 02 2023 07:45 AM
@Faraz Shaikh 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
Jul 11 2023 10:48 AM
Jul 11 2023 11:21 AM
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!!!
Jul 11 2023 04:31 PM
@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!
Jul 11 2023 09:55 PM
@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!
Jul 16 2023 02:58 PM
Aug 02 2021 01:48 PM
SolutionHi @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.