I have a spreadsheet where users fill in data using drop downs using the validation feature of excel. When this data is copied and pasted, many of the data validation drop down are wrong and contain random validation rules from other fields. Example I will copy a cell that has data validation list that will say Yes, No. When I paste it, it will contain a random list of a validation list used elsewhere such as a number range. When I press clear all for the data rules, and enter the correct ones and press ok, and then go back to see if it accepted the rules, it will be another completely different random rule used in another cell. Even if I try to have no rules and clear them all, it will always randomly populate a validation rule so I can't even manually enter data without getting errors. Anyone know what is going on? I am using the latest version of excel and not the 365 version.