Data Validation not working

[datadummy]

I am trying to figure out why my data validation drop downs are not working. I have created my list, named the list and selected the desired cells for the list. I have then went to the cell that I want my drop down in and entered the appropriate data validation settings >List>List Name and made sure the dropdown box is checked and yet my data validation is not showing up. Any ideas if I'm missing something or if a setting needs to be changed?

 

[Yongle]

Not sure what you are doing wrong

I created named range Fruit with RefersTo range A2:A5
Data validation like this

 

[datadummy]

Not sure what you are doing wrong

I created named range Fruit with RefersTo range A2:A5
Data validation like this
View attachment 18095

View attachment 18094

That's the same process I took and have used for years, I'm so confused why its not working. Just wasn't sure if I was missing a step or something somewhere along the way.

 

[Yongle]

Try doing exactly the same in a new workbook