May 18 2020 05:30 AM
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 after adding some new functions but they are not related to data validation. I mean they use the columns which are being validated but that shouldn't be a problem.)
Two columns which have data validation are D and E in page TUKT05. Column D looks at column C in page MÜSTAHSİL and column E looks at column B in page MÜSTAHSİL. And they give an error if you enter anything other than the names that are already in those columns in page MÜSTAHSİL. At least they should but they don't. I hope my explanation is clear.
May 18 2020 05:48 AM
Solution@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 ...'
May 18 2020 06:16 AM
May 18 2020 06:25 AM
May 18 2020 06:29 AM - edited May 18 2020 06:31 AM
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.
May 18 2020 05:48 AM
Solution@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 ...'