Data validation not working

[AndyD]

Hi
Im using data validation so that when you click on a cell it gives you options from a list.

However, although it has been set up to do this, it doesn't actually do this - clicking on cell doesn't bring up anything

the "in cell dropdown" option is ticked...any ideas for me?

Cheers
Andy

 

[PA HS Teacher]

I have had this problem before too:
http://www.mrexcel.com/board2/viewtopic.php?t=117776&highlight=

Still not sure why it happens though.