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

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

4 Replies

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!

Forum Discussion

DATA VALIDATION Stopped Working!

4 Replies

Resources