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). ...
The unhelpful Excel behaviour is visible to everyone using the previously attached file, Data validation column A.xlsm, if you open it in browser Excel, and make sure the Zoom is not 100%.
Then, the filtered list, of acceptable continuations, given what you have already typed, is invisible in column A:A only.
So, this isn't a fix, but you should be able to replicate the problem yourself, which might be helpful?
shafarevich It works fine for me too, both online and in the app.
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.
Right, fair point. Last bit of information with any luck, the Excel spreadsheet is shared via Teams. You need to access the Excel spreadsheet as a Teams shared file, in the browser version of Excel, and with the Zoom not at 100%. Hopefully, with that one outstanding detail, you will also be able to see, there's a snag displaying the filtered list of potential acceptable completions. Sorry, I didn't understand that that information was relevant earlier.
And this fault is only in the browser version of Excel.
Also, I can confirm that when accessed, as I expect you will have done, directly as a downloaded spreadsheet, there is no problem. But shared via Teams, the problem is there.
Unnecessary detail perhaps, but the file belongs to a group, of which I'm a member. So it isn't exactly my file, it's the group's.
