| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Data Validation
I've used the Excel 2003 Data Validation Warning and Stop funcitions in the
past successfully. I have a new spreadsheet that is not providing a pop-up when the value is not from the list. The lists are on a separate worksheet within the same workbook. I am referencing the list by 'naming' the list and using '=namedlist' as the list source. The list does appear as a drop-down with the correct values. However, I can input any other value in the column. I have tried clearing and re-adding the error alerts. They still do not work. Can someone direct me on what might be the cause? -- DME |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 Data Validation
Are you sure you haven't unchecked "show error alert after invalid data is
enterd"? Gord Dibben MS Excel MVP On Wed, 22 Apr 2009 14:26:01 -0700, DME777 wrote: I've used the Excel 2003 Data Validation Warning and Stop funcitions in the past successfully. I have a new spreadsheet that is not providing a pop-up when the value is not from the list. The lists are on a separate worksheet within the same workbook. I am referencing the list by 'naming' the list and using '=namedlist' as the list source. The list does appear as a drop-down with the correct values. However, I can input any other value in the column. I have tried clearing and re-adding the error alerts. They still do not work. Can someone direct me on what might be the cause? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 Data Validation
Yes. I am sure. 'Show error alert' is checked.
-- DME "Gord Dibben" wrote: Are you sure you haven't unchecked "show error alert after invalid data is enterd"? Gord Dibben MS Excel MVP On Wed, 22 Apr 2009 14:26:01 -0700, DME777 wrote: I've used the Excel 2003 Data Validation Warning and Stop funcitions in the past successfully. I have a new spreadsheet that is not providing a pop-up when the value is not from the list. The lists are on a separate worksheet within the same workbook. I am referencing the list by 'naming' the list and using '=namedlist' as the list source. The list does appear as a drop-down with the correct values. However, I can input any other value in the column. I have tried clearing and re-adding the error alerts. They still do not work. Can someone direct me on what might be the cause? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003-Data Validation drop down list not working? | Excel Worksheet Functions | |||
| Data Validation Excel 2003 | Excel Worksheet Functions | |||
| Tricky problem in Data validation - Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2003 - Data Validation | Excel Discussion (Misc queries) | |||
| Conditional Data Validation possible in Excel 2003? | Excel Discussion (Misc queries) | |||
Hybrid Mode
