| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| color options from drop down list | Excel Discussion (Misc queries) | |||
| how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
| Assigning values to drop-down list options | Excel Discussion (Misc queries) | |||
| validation list with drop down list of options?? | Excel Worksheet Functions | |||
| How do I set up a drop down box in Excel with a list of options f. | Excel Discussion (Misc queries) | |||
Hybrid Mode
