Getting error when adding to an drop down list

  • Thread starter Thread starter Noel
  • Start date Start date
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
 
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)
 
Back
Top