Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data validation error alert does not work
I am referencing a list on anther sheet in the same book for data validation
for cells in a range; the in-cell drop downs work fine, the input is user keyboard, recalc is auto, there are no formulas in the cells and show error alert is checked. But I get no alert, and if I enter invalid data and then serch for invald data, there is none. Anyone know why data not in the list would not be recognized as invalid? (data valdiations elsewhere in the workbook work fine). Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
data validation error alert does not work
You cannot link to cells on another sheet for data validation except if you
create a named range first. So on say sheet2 enter you list in cells say a1 apples, a2 pears, a3 oranges. Then define the range, (insert|name|define) and call it say fruit. Then in the data validation in the source enter =fruit Voila, it should work. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "timp" wrote: I am referencing a list on anther sheet in the same book for data validation for cells in a range; the in-cell drop downs work fine, the input is user keyboard, recalc is auto, there are no formulas in the cells and show error alert is checked. But I get no alert, and if I enter invalid data and then serch for invald data, there is none. Anyone know why data not in the list would not be recognized as invalid? (data valdiations elsewhere in the workbook work fine). Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
data validation error alert does not work
Martin
thanks for the suggestion - the list I am referencing is a named range (sorry i wasn't clear) Tim "Martin Fishlock" wrote: You cannot link to cells on another sheet for data validation except if you create a named range first. So on say sheet2 enter you list in cells say a1 apples, a2 pears, a3 oranges. Then define the range, (insert|name|define) and call it say fruit. Then in the data validation in the source enter =fruit Voila, it should work. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "timp" wrote: I am referencing a list on anther sheet in the same book for data validation for cells in a range; the in-cell drop downs work fine, the input is user keyboard, recalc is auto, there are no formulas in the cells and show error alert is checked. But I get no alert, and if I enter invalid data and then serch for invald data, there is none. Anyone know why data not in the list would not be recognized as invalid? (data valdiations elsewhere in the workbook work fine). Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom data validation doesn't work well | Excel Worksheet Functions | |||
Data validation don't work | Excel Discussion (Misc queries) | |||
Data Validation Error Does Not Work? | Excel Worksheet Functions | |||
Notify Alert does not work in Excel | Excel Discussion (Misc queries) | |||
Data Validation doesn't work on 1 sheet only | Excel Discussion (Misc queries) |