Forum Discussion

shafarevich's avatar
shafarevich
Copper Contributor
Jun 10, 2024

List data validation suggested completions list is not fuctioning correctly in column A:A

Hi,   I've noticed Data Validation is not listing suggested completions, in a dropdown list shortened from the original list to include only valid completions, for column A:A only.  (It used to). ...
excel
office 365
JKPieterse's avatar
JKPieterse
Silver Contributor
Jun 20, 2024
Since I can only view this file, it doesn't repro the problem for me 😕 If I click Edit a copy, the problem doesn't happen as that copies it to my personal OneDrive.
shafarevich's avatar
shafarevich
Copper Contributor
Jun 20, 2024
https://1drv.ms/x/s!AtPvPZ1Kky_bgbVv6zRqMNxbkiNPMQ?e=g1hggn

Anyone can edit. Or so I am told.

Thanks for your help.

Resources