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

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

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!?

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

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!?