Forum Discussion
Alvarom1
Oct 06, 2023Copper Contributor
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...
HansVogelaar
Oct 06, 2023MVP
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?
Alvarom1
Oct 06, 2023Copper Contributor
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
- HansVogelaarOct 06, 2023MVP
What are the versions of Excel on the two computers?
- Alvarom1Oct 06, 2023Copper ContributorComputer 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!
Álvaro- HansVogelaarOct 06, 2023MVP
It 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.