SOLVED
Home

Problem with "Data Types" toolbar in Excel. It's empty.

%3CLINGO-SUB%20id%3D%22lingo-sub-735770%22%20slang%3D%22en-US%22%3EProblem%20with%20%22Data%20Types%22%20toolbar%20in%20Excel.%20It's%20empty.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-735770%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20title%20is%20quite%20self%20explanatory.%20Here%20is%20a%20screenshot%20as%20well.%26nbsp%3B%3C%2FP%3E%3CP%3EUpdated%20to%20version%201906%20(Build%2011727.20230)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-735770%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-735871%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20%22Data%20Types%22%20toolbar%20in%20Excel.%20It's%20empty.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-735871%22%20slang%3D%22en-US%22%3E%3CP%3EHey%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F370349%22%20target%3D%22_blank%22%3E%40dostoevskyND%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20going%20into%20the%20Customize%20Ribbons%20Options%20from%20the%20File%20Tab%20(Alt%20%2B%20F%20%2B%20T)%2C%26nbsp%3Bselect%20the%26nbsp%3B%3CSTRONG%3EData%20Tab%26nbsp%3B%3C%2FSTRONG%3Eand%20%3CSTRONG%3EReset%20only%20selected%20Ribbon%20tab%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F122040i563B4AD5A92AEBB5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%221.PNG%22%20title%3D%221.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOr%2C%20If%20that%20does%20not%20work%2C%20Create%20a%20%3CSTRONG%3ENew%20Tab.%26nbsp%3B%3C%2FSTRONG%3ESelect%26nbsp%3B%3CSTRONG%3EPopular%20Command%26nbsp%3B%3C%2FSTRONG%3Ein%20the%20Choose%20Commands%20from%20dialog%20box%2C%20Find%26nbsp%3B%3CSTRONG%3EData%20Types%26nbsp%3B%3C%2FSTRONG%3ECommand%20and%20add%20it%20to%20the%20tab%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F122041i14CAEF31FDD9CBA4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%221.PNG%22%20title%3D%221.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-735923%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20%22Data%20Types%22%20toolbar%20in%20Excel.%20It's%20empty.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-735923%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F370349%22%20target%3D%22_blank%22%3E%40dostoevskyND%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAlso%20make%20sure%20you're%20online%20and%20signed%20in...%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20428px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F122051i32BD370540784A9D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-735948%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20%22Data%20Types%22%20toolbar%20in%20Excel.%20It's%20empty.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-735948%22%20slang%3D%22en-US%22%3EDid%20exactly%20as%20you%20said.%20First%20method%20didn't%20help%2C%20with%20the%20second%20there%20is%20a%20tiny%20bit%20of%20progress.%20Now%20I%20have%20the%20Icon%20of%20%22Data%20Types%22%2C%20however%20it's%20inactive.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-735955%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20%22Data%20Types%22%20toolbar%20in%20Excel.%20It's%20empty.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-735955%22%20slang%3D%22en-US%22%3EIt%20seems%20like%20I'm%20signed%20in.%20Well%2C%20at%20least%20my%20internet%20connection%20is%20up%20and%20running%20and%20there%20is%20an%20option%20to%20sign%20out.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-736202%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20%22Data%20Types%22%20toolbar%20in%20Excel.%20It's%20empty.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-736202%22%20slang%3D%22en-US%22%3ECan%20you%20take%20a%20screenshot%20of%20the%20File%20%26gt%3B%20Account%20page%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-736215%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20%22Data%20Types%22%20toolbar%20in%20Excel.%20It's%20empty.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-736215%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F370349%22%20target%3D%22_blank%22%3E%40dostoevskyND%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20Office%20repair%20could%20help.%20Without%20internet%20connection%20data%20types%20icons%20are%20visible%20but%20not%20work.%20Without%20signing-in%20with%20Microsoft%20account%20entire%20Data%20Types%20section%20is%20not%20visible%20on%20ribbon.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-736228%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20%22Data%20Types%22%20toolbar%20in%20Excel.%20It's%20empty.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-736228%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20apparently%20this%20feature%20works%20only%20with%20Office%20365%20subscription.%20If%20you%20have%20%22Office%20Home%20and%20Student%202019%22%20it%20doesn't%20work.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-737280%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20%22Data%20Types%22%20toolbar%20in%20Excel.%20It's%20empty.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-737280%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F370349%22%20target%3D%22_blank%22%3E%40dostoevskyND%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20strange.%20If%20it's%20not%20available%20for%20the%20SKU%20it%20shall%20be%20no%20Data%20Types%20section%20on%20ribbon%20at%20all.%20If%20only%20you%20didn't%20add%20it%20manually.%3C%2FP%3E%3C%2FLINGO-BODY%3E
dostoevskyND
New Contributor

The title is quite self explanatory. Here is a screenshot as well. 

Updated to version 1906 (Build 11727.20230)

8 Replies

Hey @dostoevskyND 

 

Try going into the Customize Ribbons Options from the File Tab (Alt + F + T), select the Data Tab and Reset only selected Ribbon tab

 

1.PNG

 

Or, If that does not work, Create a New Tab. Select Popular Command in the Choose Commands from dialog box, Find Data Types Command and add it to the tab

 

1.PNG

@dostoevskyND 

 

Also make sure you're online and signed in...

 

image.png

Did exactly as you said. First method didn't help, with the second there is a tiny bit of progress. Now I have the Icon of "Data Types", however it's inactive.
It seems like I'm signed in. Well, at least my internet connection is up and running and there is an option to sign out.
Can you take a screenshot of the File > Account page
Highlighted

@dostoevskyND 

 

Perhaps Office repair could help. Without internet connection data types icons are visible but not work. Without signing-in with Microsoft account entire Data Types section is not visible on ribbon.

Solution

So apparently this feature works only with Office 365 subscription. If you have "Office Home and Student 2019" it doesn't work. 

@dostoevskyND 

That's strange. If it's not available for the SKU it shall be no Data Types section on ribbon at all. If only you didn't add it manually.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies