| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop Down List Validation | Excel Discussion (Misc queries) | |||
| Drop Down List + Validation | Excel Discussion (Misc queries) | |||
| I have lost the in cell drop down in validation | Excel Worksheet Functions | |||
| validation list with drop down list of options?? | Excel Worksheet Functions | |||
| Data Validation using List (But needs unique list in drop down lis | New Users to Excel | |||
Hybrid Mode
