lost the drop down list (the validation still exist)

[NirOrtal]

Hi

I have Excel 2003.
I have a workbook with few worksheets. Every sheet has few drop-down lists.
I ‘lost’ all drop-down lists on one of the sheet (the other sheets work fine).
The drop-down lists still exist in the validation menu.
Even if I create a new drop-down list it is not working (only on this page)

What I suppose to do?

 

[DStrong]

It sounds like the lists got deleted somehow. How are the lists in the
validation menu, are they a named range or listed like $A$1:$A$11?

 

[NirOrtal]

named range

It sounds like the lists got deleted somehow. How are the lists in the
validation menu, are they a named range or listed like $A$1:$A$11?

 

[Debra Dalgleish]

There's a list of reasons for missing arows here:

http://www.contextures.com/xlDataVal08.html#ArrowsNotVisible

with suggestions for fixing the problems.

 

[NirOrtal]

THANX!!!!!!!!

There's a list of reasons for missing arows here:

http://www.contextures.com/xlDataVal08.html#ArrowsNotVisible

with suggestions for fixing the problems.



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com