Data validation issues

[Jonywalker]

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.

 

[Jon Peltier]

First, Microsoft 365 is the latest version of Excel. It gets regular updates with new features, typically on a monthly basis, depending on your settings. The perpetual versions, like 2021 and 2019 are static, and only get security updates, not new features.

Second, could you share what your data validation rules are? Part of your problem may relate to using relative rather than absolute references for the lists.