Data types missing - Excel 365

Question

Hi,

sometime during February Data Type section that allowed to get stock information in Excel has disappeared. I have the option to add it manually by customizing the Ribbon but then it just stays gray and doesn't let me choose anything.

From the spreadsheet I can see that stock information was updated for the last time with real-time information on February 8.

I have Microsoft 365 Apps for enterprise subscription through my university and Excel version 16.0.13127.21210.

How can I get back the option of seeing/updating to real-time stock data on Excel?

Uninstalling and reinstalling Office did not help.

Answer 1

Hi Raul,

Based on your information, you are using Semi-Annual channel of Office and your Stock Data Type in toolbar is greyed out.

Based on my test, we have the same behavior in the latest version of Semi-Annual channel (Version 2008 (Build 13127.21216)), we have searched in other threads that user are able to use Stock data type after updating Office from Semi-Annual Channel to Monthly Enterprise Channel or Current Channel. (Link)

Please follow the steps in this article to update Office:  How to switch from Semi-Annual Channel to Monthly Channel for the Office 365 suite?

Best Regards,

Ivy

Answer 2

Hi Ivy,

thanks to your help I was able to change it to Current channel and now Data Type is not greyed out anymore.

But it still doesn't give me the possibility of choosing anything from there. Clicking on it doesn't open any options to choose from.

Right now my Excel is Version 2101 (Build 13628.20448 Click-to-Run).

Excel for Microsoft 365 MSO (16.0.13628.20128).

Do you have any suggestions to get Stocks, Geography etc back to Data Types so I could get my real-time stock info back working on my spreadsheets?

Answer 3

Hi Raul,

Pretty thank you for your reply.

I’m writing this reply to follow up on this case, per your description, and I investigate further and find the new feature-- Data types, is gradually rolled out to Microsoft 365 Family or Personal subscribers.

You can the relevant information according to What linked data types are available in Excel? - Office Support (microsoft.com). For more information: When do I get the newest features for Microsoft 365? - Office Support.

And I also test on my end, it does show and can be used when I sign in to Office apps with Microsoft 365 account (Microsoft 365 Family or Personal account). Excel data types: Stocks and geography - Office Support (microsoft.com).

So, we sincerely suggest you can sign in to Office apps with Microsoft Personal or Family account to activate the new feature. Another side, we sincerely suggest you can wait more time to get the features if your organization allows.

Hope my reply can help you. And thank you for your time. 😊 Have a good day!

Best regards,

Cindy

---

* Beware of scammers posting fake support numbers here.

* Kindly Mark and Vote this reply Yes if it helps, as it will be beneficial to more community members reading here.

Answer 4

Hi Raul,

Welcome to share any updates when you have time if you need further help.

Best regards,

Cindy