lost the drop down list (the validation still exist)
 

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?

lost the drop down list (the validation still exist)
 

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?

lost the drop down list (the validation still exist)
 

named range

"DStrong" wrote:

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?

lost the drop down list (the validation still exist)
 

There's a list of reasons for missing arows he

http://www.contextures.com/xlDataVal...rowsNotVisible

with suggestions for fixing the problems.

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?



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

lost the drop down list (the validation still exist)
 

THANX!!!!!!!!

"Debra Dalgleish" wrote:

There's a list of reasons for missing arows he

http://www.contextures.com/xlDataVal...rowsNotVisible

with suggestions for fixing the problems.

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?



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