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" wrote:

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?