I have lost the in cell drop down in validation

[Stan Lawson]

I have used data validation with list and have set the in-cell drop down.
But I have lost the drop down arrow. This is just on one worksheet in the
workbook of several worksheets and all of the others the incell drop down
works fine. and I can copy the cell from the one worksheet to others and it
works. Some how I must have turned off the drop down function, but I don't
how

 

[Ken Wright]

If you hit data / Validation does it still show it as being linked to a
list.

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

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[Bob Phillips]

We have come across this before, but no-one seems to know a way of getting
it back. AFAIK you will have to rebuild your worksheet.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)