How to add Data Types to the Excel Data Ribbon

Dear @Ric Wilson,

Thank you for reaching out to the Microsoft Q&A forum. We’re happy to assist you.

There are several possible reasons why the Data Types option appears greyed out in Excel, kindly try these steps to help us narrow down the issue and see if it persists:

1. Unsupported license or unsupported language.

• Go to File > Account in the Excel application and verify that your Office 365 subscription account is displayed under User Information.
• In Options > Language, set an authoring language such as English and move it to the top if needed; some environments reported Data Types enabling after language adjustments.

1. If your license is valid, confirm that you’re using the latest version of Excel. Update Office if necessary. Visit this link to learn how to update your Office Apps: How to update Microsoft 365 or Office for Windows
2. Create a new worksheet or workbook to check whether the issue occurs across all files or only in a specific one. Sometimes, the problem is related to sheet configuration.
3. If the issue persists in all sheets, run an Office Repair from Control Panel. Visit here to learn more: Repair an Office application
4. If none of the above steps work, reinstall Office. Visit here to learn more: Download, install, or reinstall Microsoft 365 or Office 2024 on a PC or Mac, Reinstall Office from the Microsoft Store app

Since I do not have access to your device environment, there may be cases where my recommended solutions do not fully resolve the issue or other problems appear. If that happens, please update me right away with any new details or results in the Comment. I will do my best to support you and help find a solution as quickly as possible.