errors with validation from list

[Cam1234]

Hi All,

I'm trying to limit acceptable entries in document I'm creating. What I'm
trying to do is make it so a user can only enter part numbers from a specific
list. The list is 34 part numbers long.

I'm named this list as 'CH', and then gone into Data>Validation then Allowed
'List', and the Source as =CH.
I want to be able to either type the number in, or choose it from the list.

I can choose any of the 34 parts from the list, but when I try to manually
enter any value except the first, I get an error message saying "The value
you entered is not valid. A user has restricted values that can be entered
into this cell."

Any ideas? I am using Excel 2000.

Thanks!!

 

[VanguardLH]

in message

I'm trying to limit acceptable entries in document I'm creating.
What I'm
trying to do is make it so a user can only enter part numbers from a
specific
list. The list is 34 part numbers long.

I'm named this list as 'CH', and then gone into Data>Validation then
Allowed
'List', and the Source as =CH.
I want to be able to either type the number in, or choose it from
the list.

I can choose any of the 34 parts from the list, but when I try to
manually
enter any value except the first, I get an error message saying "The
value
you entered is not valid. A user has restricted values that can be
entered
into this cell."

Any ideas? I am using Excel 2000.

And how is this an Outlook issue? Once you figure out how to use
Excel, then attach the .xls document to your e-mail. The recipient
will obviously also need to have Excel installed or a viewer for that
file format (although you say you want them to enter values which
means a viewer won't work).