Adding more options in a drop down list
 

I would like to add to a drop down list that is in a column of an excel
spreadsheet. I can insert a line and then when I try to add or change the
drop down list, I get the following error:
"THE VALUE YOU ENTERED IS NOT VALID. A USER HAS RESTRICTED VALUES THAT CAN
BE ENTERED INTO THIS CELL."

I received this spreadsheet from a coworker that had created it. I believe
they may have copied the information from another spreadsheet. Is it possible
she brought some protected information with it?

Adding more options in a drop down list
 

The dropdown list is most likely created through Data Validation and will
limit user to what is on the list.

If you want to type something other than what is in the dropdown you must
uncheck the error alert.

This won't add to the items in the list but will allow you to type something
not on the list.

If you want to permanently add to the list, you must edit the source list
range.

Data ValidationAllowListSource.

See where the list comes from then edit that source.


Gord Dibben MS Excel MVP

On Mon, 9 Feb 2009 07:48:01 -0800, Noel
wrote:

I would like to add to a drop down list that is in a column of an excel
spreadsheet. I can insert a line and then when I try to add or change the
drop down list, I get the following error:
"THE VALUE YOU ENTERED IS NOT VALID. A USER HAS RESTRICTED VALUES THAT CAN
BE ENTERED INTO THIS CELL."

I received this spreadsheet from a coworker that had created it. I believe
they may have copied the information from another spreadsheet. Is it possible
she brought some protected information with it?

Adding more options in a drop down list
 

There is no source listed.

"Gord Dibben" wrote:

The dropdown list is most likely created through Data Validation and will
limit user to what is on the list.

If you want to type something other than what is in the dropdown you must
uncheck the error alert.

This won't add to the items in the list but will allow you to type something
not on the list.

If you want to permanently add to the list, you must edit the source list
range.

Data ValidationAllowListSource.

See where the list comes from then edit that source.


Gord Dibben MS Excel MVP

On Mon, 9 Feb 2009 07:48:01 -0800, Noel
wrote:

I would like to add to a drop down list that is in a column of an excel
spreadsheet. I can insert a line and then when I try to add or change the
drop down list, I get the following error:
"THE VALUE YOU ENTERED IS NOT VALID. A USER HAS RESTRICTED VALUES THAT CAN
BE ENTERED INTO THIS CELL."

I received this spreadsheet from a coworker that had created it. I believe
they may have copied the information from another spreadsheet. Is it possible
she brought some protected information with it?

Adding more options in a drop down list
 

Okay, I got the error to go away. But, how do I enter NEW items for the list?

"Gord Dibben" wrote:

The dropdown list is most likely created through Data Validation and will
limit user to what is on the list.

If you want to type something other than what is in the dropdown you must
uncheck the error alert.

This won't add to the items in the list but will allow you to type something
not on the list.

If you want to permanently add to the list, you must edit the source list
range.

Data ValidationAllowListSource.

See where the list comes from then edit that source.


Gord Dibben MS Excel MVP

On Mon, 9 Feb 2009 07:48:01 -0800, Noel
wrote:

I would like to add to a drop down list that is in a column of an excel
spreadsheet. I can insert a line and then when I try to add or change the
drop down list, I get the following error:
"THE VALUE YOU ENTERED IS NOT VALID. A USER HAS RESTRICTED VALUES THAT CAN
BE ENTERED INTO THIS CELL."

I received this spreadsheet from a coworker that had created it. I believe
they may have copied the information from another spreadsheet. Is it possible
she brought some protected information with it?