Forum Discussion
Convert to Checkboxes
Apparently, it only happens within a structured table after you enter a few y or n. See screenshot below. Don't think it can be switched off.
I tried exactly that, both with j/n (as my Ux is in Dutch) and with y/n, neither triggered the pop-up.
interesting, I can't reproduce either. I have tried multiple online accounts, created structured tables in existing and new workbooks. I have tried builds:
16.0.18618.42309
16.0.18619.42308
that all said, what I wanted to test was if you could turn protection on to block/stop this
I get it all the time. My build is 16.0.18619.42308.
Let's see what then OP has to say about it.
Hello, Yes, that's what I found too.
Not sure what happened to my previous reply but that's exactly what happens.
It's a real pain as it's unwanted behaviour and it's too tempting for the users to resist.
I've found a work around for now which is to turn on data validation for the column and give the options "y" and "n" in a list. It stops the dialogue from popping up.
