Anyone know a reason my cell drop down validation to a named list will still accept any typed entry? The drop down works and shows the list. Selecting one of them does populate the cell. But so does just typing whatever you want in there.
That's not the way it's supposed to work. What have I done wrong?
That's not the way it's supposed to work. What have I done wrong?