| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down list
I'm trying to create a simple drop down list but when I enter the name of the
column it gives this error, "The List Source must be a delimited list, or a reference to a single row or column" It is a simple list in a single column, why do I keep getting this error? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
drop down list
Can you give us your actual formula? And if you are trying to do a list of a
named range, can you give us the formula for the named range? -- ** John C ** "Zeus" wrote: I'm trying to create a simple drop down list but when I enter the name of the column it gives this error, "The List Source must be a delimited list, or a reference to a single row or column" It is a simple list in a single column, why do I keep getting this error? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
drop down list
I followed the instruction exactly from this site
http://www.contextures.com/xlDataVal01.html#Create and I still get the same error "John C" wrote: Can you give us your actual formula? And if you are trying to do a list of a named range, can you give us the formula for the named range? -- ** John C ** "Zeus" wrote: I'm trying to create a simple drop down list but when I enter the name of the column it gives this error, "The List Source must be a delimited list, or a reference to a single row or column" It is a simple list in a single column, why do I keep getting this error? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
drop down list
Still need formulas to help any further.
-- ** John C ** "Zeus" wrote: I followed the instruction exactly from this site http://www.contextures.com/xlDataVal01.html#Create and I still get the same error "John C" wrote: Can you give us your actual formula? And if you are trying to do a list of a named range, can you give us the formula for the named range? -- ** John C ** "Zeus" wrote: I'm trying to create a simple drop down list but when I enter the name of the column it gives this error, "The List Source must be a delimited list, or a reference to a single row or column" It is a simple list in a single column, why do I keep getting this error? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
drop down list
I don't know what I did but it is working now, thanks anyway.
"John C" wrote: Still need formulas to help any further. -- ** John C ** "Zeus" wrote: I followed the instruction exactly from this site http://www.contextures.com/xlDataVal01.html#Create and I still get the same error "John C" wrote: Can you give us your actual formula? And if you are trying to do a list of a named range, can you give us the formula for the named range? -- ** John C ** "Zeus" wrote: I'm trying to create a simple drop down list but when I enter the name of the column it gives this error, "The List Source must be a delimited list, or a reference to a single row or column" It is a simple list in a single column, why do I keep getting this error? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
| how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Linear Mode
