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

Adding more options in a drop down list 4
Excel Drop Down lists 1
Protecting sheets with drop down boxes 6
DROP DOWN LIST WHEN SPREAD SHEET OPENS 5
Inserting info in a drop down box 2
Drop Down List in Excel 2007 1
Filtered drop down list 2
Drop down list indicator 8

Top