Yes I have.
In another sheet, I have a named list called "sites".
When I select a cell and do Data / Validation, it is there(=sites).

"Ken Wright" wrote in message
...
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" wrote in message
...
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 ToolsOptionsViewObjects 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