| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Data Validation, Invalid Data Imput
I'm using data validation for a drop down list in several sheets in a
workbook. I have them all accessing a list that is on worksheet one. Access is through defining a name for the list called =salespeople. The problem is, I can't get the Invalid Data Stop message to work. If I access the list without the using the name =salespeople for the source and just use direct cell references it works fine. Is this a glitch or by design? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation does not work when selecting another cell. | Excel Discussion (Misc queries) | |||
| data validation lists | Excel Discussion (Misc queries) | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions | |||
Threaded Mode
