| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Phantom Data Validation
In Excel 2003 when I insert a row into a particular existing sheet, no matter
at which row I insert, all cells in column A from row 20 downwards then have a data validation in them. The data validation displayed exists in another cell in the sheet, C11, but the drop-down choice in the column A cells shows only part of the full validation list in C11. If I delete the newly inserted row, the phantom data validations disappear. The cells in Column A have existing data in them, mainly field names. What would cause this? How do I stop it? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| existing data in case of data validation | Excel Discussion (Misc queries) | |||
| From several workbooks onto one excel worksheet | 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 | |||
Threaded Mode
