Forum Discussion
List data validation suggested completions list is not fuctioning correctly in column A:A
shafarevich Can you share a stripped-down version of a file that exhibits the behavior by any chance? (please remove sensitive information first!)
The slight issue is that this file works fine for me, browser based and app.
Additionally, the user believes he has resolved the issue by updating the version of Teams he is running.
He highlights that he no longer has the option to upgrade.
He thought the error stemmed from having 2 versions of Teams conflicting? I'm not sure this is correct.
Anyway, this file captures the basic design that used to failed only on column A on his machine.
I had to use INDIRECT to get the table references to work. (I mean, exactly as I had to originally, this is the stripped down structure verbatim).
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)