Forum Discussion

mangatic's avatar
mangatic
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...
excel
  • mtarler's avatar
    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 ...'

mangatic's avatar
mangatic
Copper Contributor
May 18, 2020
Wait nope, now it gives error no matter what....
mangatic's avatar
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.

Resources