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
Highlighted
dostoevskyND
New Contributor

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

Updated to version 1906 (Build 11727.20230)

8 Replies
Highlighted

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

Highlighted

@dostoevskyND 

 

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

 

image.png

Highlighted
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.
Highlighted
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.
Highlighted
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. 

Highlighted

@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
vlookup
Novice6 in Excel on
1 Replies
Average set of values if 2 criteria are met
jtorrens in Excel on
1 Replies
Refresh query to add new columns
Caesarus7 in Excel on
0 Replies
Frozen excel project
Mrkeats in Excel on
0 Replies