Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation...I need to add more entries!!
Hi,
I am having difficulty in adding new enteries to my data validation list, every time I try to enter a new entry on the list it starts to over write my existing enteries. Does anyone know if there is a maximum number of characters allowed per drop down!? Or does anyone know how to get around this problem!? Thanks, C |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation...I need to add more entries!!
Put the values in a range, and point the DV at that range rather then embed
them. -- __________________________________ HTH Bob "Davieslondon" wrote in message ... Hi, I am having difficulty in adding new enteries to my data validation list, every time I try to enter a new entry on the list it starts to over write my existing enteries. Does anyone know if there is a maximum number of characters allowed per drop down!? Or does anyone know how to get around this problem!? Thanks, C |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation...I need to add more entries!!
I wonder if its because you're typing items directly into the DV's source box?
You could try the other options (eg: named/defined range) in Debra's page: http://www.contextures.com/xlDataVal01.html -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- "Davieslondon" wrote: I am having difficulty in adding new enteries to my data validation list, every time I try to enter a new entry on the list it starts to over write my existing enteries. Does anyone know if there is a maximum number of characters allowed per drop down!? Or does anyone know how to get around this problem!? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation...I need to add more entries!!
Thanks very much.
C "Bob Phillips" wrote: Put the values in a range, and point the DV at that range rather then embed them. -- __________________________________ HTH Bob "Davieslondon" wrote in message ... Hi, I am having difficulty in adding new enteries to my data validation list, every time I try to enter a new entry on the list it starts to over write my existing enteries. Does anyone know if there is a maximum number of characters allowed per drop down!? Or does anyone know how to get around this problem!? Thanks, C |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation...I need to add more entries!!
I think it was, but have now resloved the issue.
Thank you. "Max" wrote: I wonder if its because you're typing items directly into the DV's source box? You could try the other options (eg: named/defined range) in Debra's page: http://www.contextures.com/xlDataVal01.html -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- "Davieslondon" wrote: I am having difficulty in adding new enteries to my data validation list, every time I try to enter a new entry on the list it starts to over write my existing enteries. Does anyone know if there is a maximum number of characters allowed per drop down!? Or does anyone know how to get around this problem!? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LIMITING DATA VALIDATION ENTRIES | Excel Discussion (Misc queries) | |||
How do I get data validation to disallow specific entries | Excel Worksheet Functions | |||
Data Validation not preventing invalid entries | Excel Discussion (Misc queries) | |||
Data Validation for Weekday entries only | Excel Worksheet Functions | |||
Using Data Validation - how do I allow other entries | New Users to Excel |