2002 Data Validation blank

  • Thread starter Thread starter David Priest
  • Start date Start date
D

David Priest

On sheet 1 in a workbook, I can set a data validation list
up for a cell. It works.

On sheet 2, an exact copy of the first sheet, I also set
up data validation for a cell. It does not work.

In each case, the list is on the respective sheet.

I have tried saving the book with different names
under "save as ..." to try to enforce the validation, but
to no avail.

When I select data validation for the cell that is to be
validated on sheet 2, it displays that it is in fact a
list and the range is proper, but I do not get the drop
down list when clicking on the cell. The "input message"
and "error alerts" do work.

Any ideas?

Thanks,

dp
 
One common source of error is that the cells containing
the validation criteria are incorrect. If possible, the
cell references should be absolute. Otherwise, use with
caution.
 
Using an absolute range and deleted all values from all
cells - still won't pop up that list ...
 
Hi David,

In order to use a DV drop down list with the source being
located on a different worksheet, you have to give the
source data a defined name.

Biff
 
Thanks for the various suggestions. The only way to solve
this problem was to create a new sheet, copy the values,
formats, etc from the old sheet to the new sheet, then
redo the data validation.

dp
 
Back
Top