Getting error when adding to an drop down list

N

Noel

I am trying to add more options to a drop down list in an excel spreadsheet
and I am receiving the following error:
"The vaulie you entered is not valid. A user has restricted values that can
be entered into this cell."

This spreadsheet was created by a coworker and then given to me. I believe
they copied the information from another spreadsheet so could it be possible
that some protected information was copied over?

Thanks
 
C

Chip Pearson

That message is cause by Data Validation. Data Validation allows you
to restrict the type of data that can be entered into a cell. Select
the cell(s) that are giving you grief, go to the Data menu and choose
Validation. There, select "any value" on the Allow list. This will
remove validate constraints and enter any value.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error received when trying to add to a drop down list 0
How to make repeating drop-down lists? 2
Drop down list control value in vba 2
Adding more options in a drop down list 4
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Drop down lists in seperate columns 5
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Link a text box based on drop down box with four options MS Word 365 0

Top