Stock Quotes in MS 365 Excel for Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-3279479%22%20slang%3D%22en-US%22%3EStock%20Quotes%20in%20MS%20365%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3279479%22%20slang%3D%22en-US%22%3E%3CP%3EI%20get%20the%20following%20alert%20when%20attempting%20to%20use%20stock%20quotes%20in%20MS%20365%20Excel%20for%20Mac%3A%20%22We%20need%20to%20fix%20your%20account.%20Select%20Microsoft%20Excel%20from%20the%20top%20menu%20%26gt%3B%20Sign%20Out%2C%20then%20sign%20back%20in%20with%20the%20account%20associated%20with%20a%20subscription.%22%20When%20I%20did%20this%2C%20the%20stock%20quotes%20icon%20under%20the%20data%20tab%20disappeared.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20used%20the%20MS%20Office%20License%20Removal%20Tool%202.7%20to%20remove%20and%20reinstall%20the%20license.%20This%20was%20also%20unsuccessful.%20Currently%2C%20I%20don't%20have%20the%20stock%20quotes%20icon%20under%20the%20data%20tab.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20running%20macOS%20Monterey%2C%20version%2012.3%20with%20an%20Apple%20M1%20chip.%20The%20product%20I'm%20using%20is%20Microsoft%20Excel%20for%20Mac%2C%20Version%2016.59%20(22031300).%20License%3A%20Microsoft%20365%20Subscription.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20reason%20for%20purchasing%20MS%20365%20was%20to%20use%20the%20stock%20quotes%20function%20in%20Excel%20to%20get%20prices%20for%20the%20stocks%20and%20ETFs%20in%20my%20investment%20portfolio.%20I'm%20now%20using%20Google%20Sheets.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECase%20number%20from%20MS%20Support%3A%201037702822%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20with%20this%20problem%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEd%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3279479%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3336456%22%20slang%3D%22en-US%22%3ERe%3A%20Stock%20Quotes%20in%20MS%20365%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3336456%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1356966%22%20target%3D%22_blank%22%3E%40edkain%3C%2FA%3E%26nbsp%3BI%20am%20having%20the%20exact%20same%20problem%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3282594%22%20slang%3D%22en-US%22%3ERe%3A%20Stock%20Quotes%20in%20MS%20365%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3282594%22%20slang%3D%22en-US%22%3EI%20have%20a%20similar%20problem.%20I'm%20registered%20and%20logged%20in%20using%20my%20365%20account%2C%20but%20I%20have%20no%20datatype%20options%20under%20the%20data%20tab.%20I'm%20also%20using%20MS365%20for%20Mac.%3C%2FLINGO-BODY%3E
Occasional Visitor

I get the following alert when attempting to use stock quotes in MS 365 Excel for Mac: "We need to fix your account. Select Microsoft Excel from the top menu > Sign Out, then sign back in with the account associated with a subscription." When I did this, the stock quotes icon under the data tab disappeared. 

 

I also used the MS Office License Removal Tool 2.7 to remove and reinstall the license. This was also unsuccessful. Currently, I don't have the stock quotes icon under the data tab.  

 

I'm running macOS Monterey, version 12.3 with an Apple M1 chip. The product I'm using is Microsoft Excel for Mac, Version 16.59 (22031300). License: Microsoft 365 Subscription.  

 

My reason for purchasing MS 365 was to use the stock quotes function in Excel to get prices for the stocks and ETFs in my investment portfolio. I'm now using Google Sheets. 

 

Case number from MS Support: 1037702822

 

Any help with this problem would be greatly appreciated.

 

Ed

 

 

 

 

  

2 Replies
I have a similar problem. I'm registered and logged in using my 365 account, but I have no datatype options under the data tab. I'm also using MS365 for Mac.

@edkain I am having the exact same problem