Forum Discussion
Solved
DATA VALIDATION Stopped Working!
Hey there! Here I am yet another call for help. This attached excel I have been working on has some data validation, which are necessary, but after some time they just stopped working. (Especially af...
mangatic Your data validation is using "Custom" and a formula = [name]
Try "List" and get rid of the "=" so the box only has the [name] range in it.
Don't forget to select the whole range or just select the 'apply to all cells ...'
Thanks, I'll try that but if I remember correctly it was like that before and still didn't work so I changed it to Custom. Let me see.
Huh, now it works but I can swear it was like that before, maybe with an = sign? Still thank you very much!
Huh, now it works but I can swear it was like that before, maybe with an = sign? Still thank you very much!