Forum Discussion
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). ...
Here's a link demonstrating the fault, becaue it is the same file, but shared though Teams.
Unfortunately, "share with all" is barred by my organisation, so it's from a personal account. It's still me though, and it's the same file.
https://1drv.ms/x/s!AtPvPZ1Kky_bgbVvCtW4wCJtA2so-g?e=bpol2O
Hmm... catchy name!
Change Zoom to be not 100%, and completion list is invisble in column A.
(but if security concerns you, just share the orginal file with yourself through Teams, you get the same glitchy effect)
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.
- https://1drv.ms/x/s!AtPvPZ1Kky_bgbVv6zRqMNxbkiNPMQ?e=g1hggn
Anyone can edit. Or so I am told.
Thanks for your help.
