Data validation removed after save to .xlsm file

mikefenton 

It is unusual for data validation settings to be removed from cells when saving a workbook as .xlsm, especially if the data validation was working fine before the conversion.

Here are a few suggestions to troubleshoot the issue:

1. Check for any macro or VBA code: If your workbook contains any macros or VBA code, ensure that they are not inadvertently removing or modifying the data validation settings. Review the code and make sure there are no conflicting operations.
2. Remove and reapply data validation: Try removing the data validation settings from the affected cells, save the workbook, and then reapply the data validation. This process can sometimes help fix any inconsistencies or corruption in the data validation settings.
3. Repair or reinstall Office: If the issue persists, it's possible that there might be some corruption or conflict within the Office installation itself. Try repairing or reinstalling Office to ensure a clean installation.
4. Test on a different computer: If available, try opening the workbook on a different computer with a different Office installation. This can help determine if the issue is specific to your computer or if it persists across different environments.

Remember to keep backups of your workbook before attempting any troubleshooting steps to avoid any potential data loss.