You can create a macro file which will open the the input and remove the data validation,
Sub test()
Dim wb As Workbook
Dim sht As Worksheet
Set wb = Workbooks.Open(“*\Desktop\New Microsoft Excel Worksheet.xlsx”)
Set sht = wb.Worksheets(“Sheet4”)
sht.Cells.Validation.Delete
End Sub
Let me know the result
Thanks,
Suresh J