Jul 03 2019 12:56 AM - edited Jul 03 2019 12:56 AM
The title is quite self explanatory. Here is a screenshot as well.
Updated to version 1906 (Build 11727.20230)
Jul 03 2019 01:38 AM
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
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
Jul 03 2019 02:14 AM
Jul 03 2019 02:24 AM
Jul 03 2019 02:25 AM
Jul 03 2019 04:54 AM
Jul 03 2019 05:01 AM
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.
Jul 03 2019 05:10 AM
SolutionSo apparently this feature works only with Office 365 subscription. If you have "Office Home and Student 2019" it doesn't work.
Jul 03 2019 03:13 PM
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.
Jan 05 2021 01:10 PM
@dostoevskyND I'm still having the exact same problem but I am a Microsoft 365 subscriber so that may not be the issue / only issue you were having. Anyone find a resolution to this?
Apr 14 2022 05:29 AM
@dostoevskyND, I had the same issue. Just logged out from all account in Excel and then signed in again. It helped
Jul 03 2019 05:10 AM
SolutionSo apparently this feature works only with Office 365 subscription. If you have "Office Home and Student 2019" it doesn't work.