Have you tried Data / Validation whilst in those cells, to confirm that it
is fact pulling from where you think it is.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"lunker55" <this_is_not_my_email_address@hotmail.com> wrote in message
news:eAQn8R0GFHA.3244@TK2MSFTNGP09.phx.gbl...
> I have a Data Validation drop down that has stopped working in one sheet
> only.
> I made a new Data Validation in the same book, but in another sheet, and
it
> works.
> I have checked Tools>Options>View>Objects and SHOW ALL is checked.
> Any ideas??
> The drop down doesn't show and the error alert doesn't pop up if I enter
an
> invalid entry(It is turned on)
> Joe
>
>
>