Forum Discussion
Excel for mac - Stocks data doesnt work
Duplication of https://techcommunity.microsoft.com/t5/excel/excel-for-mac-data-field-stock-exchange/m-p/1042578
Did you try the suggested solutions given in the above link? It worked there!
And what version of Excel are you on? The picture below comes from the help section.
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.
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.
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.
