Forum Discussion
Data Validation with unique values
Hi, I have a question on Data Valitation. I have a list with duplicated values on it. I do data validation with this list to get a drop list. When done with one computer I get a drop list with onl...
If you select the cell with the drop-down, then click Data Validation on the Data tab of the ribbon, what is the Source on the first computer, and what is the Source on the second computer?
Hi,
it is the same complete list in both computers.
I assume that it has to do something with the excel version, as I send the same file from one computer to another, and it behaves differently
Thanks
Alvaro
it is the same complete list in both computers.
I assume that it has to do something with the excel version, as I send the same file from one computer to another, and it behaves differently
Thanks
Alvaro
What are the versions of Excel on the two computers?
- Computer 1 - Version 2309 (16827.20130) (shows unique values)
Computer 2 - Version 2303 (16227.20318) (shows same values repeated)
I checked same file with a thrid computer MAC - with version 16.77.1 (23091703) and shows also values repeated).
Computer 1 is the only one that shows correctly only unique values in the drop down list
Thanks!
ÁlvaroIt looks like Microsoft quietly introduced this in Excel for Windows in the August 2023 update, together with the AutoComplete feature in data validation drop-downs. That's why it works in version 2309 but not in 2303. It'll probably be released for Mac pretty soon.