We have recently migrated all our excel onto Sharepoint and have encountered a new issue. A workbook has been opened in App (desktop) and all the Data Validation that was in the previous version has disappeared. Not the dropdown arrow, but the actual Data Validation. When checked the Data Validation has reverted to Any instead of List with the associated dropdowns for each column. Ive exhausted all attempts to find out why. Has anyone had a similar experience and was able to resolve the issue? Thanks.