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?