Hi,

My colleague was working on an Unprotected excel document and he wanted
to apply a validation list (list is in A1 through A5) in region C2
through C10. We had selected C1 through C10 and went to
Data--Validation-LIst then selected A1 through A5 and pressed OK. Now,
when the active cell is any of the cells through C2 through C10, then
we dont get down arrow associated with valdation list? Rather the cell
has no validation applied when we reselect these cells and go to data
-- validation. Note we are able to apply validation on other workbooks.
(This happened in Office 2003 and we havent tried this whether it
happens in 2002 or not)

Why is it happening?

Regards,
Hari
India