2002 Data Validation blank

[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

 

[jr]

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.

 

[David Priest]

Using an absolute range and deleted all values from all
cells - still won't pop up that list ...

 

[Biff]

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

 

[David Priest]

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