To troubleshoot the issue with the grayed out Data ribbon, you can try the following:

1. Check if the workbook is in Compatibility Mode. If it is, save the workbook in the current Excel format to enable all features.
2. Make sure that the workbook is not protected. If it is, unprotect the workbook to enable all features.
3. Check if the workbook has any add-ins that may be causing the issue. Try disabling the add-ins and see if the Data ribbon becomes active.
4. If none of the above solutions work, try repairing or reinstalling Microsoft Office.

I hope this helps! Let me know if you have any further questions.