Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation From List Not Working
Hi All,
I'm using Excel 2003. On one tab I have a range named Cats with category names. On all my other sheets I'm setting column F to use validation based on this list. When I first apply the validation (i.e. Allow: List, Source: =Cats) the drop down appears when in any effected cell, but erroneous entries are still allowed. Then when I save and reopen the file the validation isn't there at all (i.e. no dropdown list and no indication of any previous settings in the validation dialog box.) I use this same method in a different file at least once a month without an issue. Any idea what I could be doing wrong? Thanks Erin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation Dropdown List Not Working | Excel Discussion (Misc queries) | |||
Validation problem with list 2 working | Excel Discussion (Misc queries) | |||
Validation list boxes not working | Excel Discussion (Misc queries) | |||
list validation drop-down not working | Excel Discussion (Misc queries) | |||
Validation List Stops working | Excel Discussion (Misc queries) |