Forum Discussion

Seshu1992's avatar
Seshu1992
Copper Contributor
Mar 15, 2020

Excel for mac - Stocks data doesnt work

I was never able to get the Share Price or any other fields auto fill in Excel for Mac. It works fine on Windows or Cloud based Excel but not on a macbook.        None of the options like P...
Excel on Mac
Need Help
Seshu1992's avatar
Seshu1992
Copper Contributor
Mar 15, 2020

Riny_van_Eekelen Thanks for getting back.

 

Excel version is uptodate. I am also logged into Excel with my office 365 account. This is a personal account. Not sure if any subscription to Office 365 is needed for the same.

 

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Mar 15, 2020

Seshu1992 I believe the help message is clear in saying that you must be a subscriber. I'm on a monthly program and it works for me.

Attached a workbook with some examples. See if it works for you.

  • Seshu1992's avatar
    Seshu1992
    Copper Contributor
    Mar 15, 2020

    Riny_van_Eekelen Thanks for the file. I logged out of personal account and logged into my corporate account which has "Office 365 E3" subscription. The file you shared still gave the same error. So, I cleared all the cached Microsoft installations and reinstalled the latest version and tried again. Still got the same error. 

     

    I will get a trial for of Premium Office 365 and see if it starts working. 

Resources