Forum Discussion

Copper Contributor

May 18, 2020

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...

WIP.xlsx673 KB

excel

mtarler
May 18, 2020
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 ...'

mtarler

Silver Contributor

May 18, 2020

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 ...'

mangatic
Copper Contributor
May 18, 2020
Wait nope, now it gives error no matter what....
- mangatic
  Copper Contributor
  May 18, 2020
  If I put = in front of [name] it doesn't give any error, if I delete = it gives error no matter what I write. Both situations are not ideal. I'm using Excel 2010 btw.
mangatic
Copper Contributor
May 18, 2020
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!