I have an Excel 2007 workbook that includes data validation set on a number
of cells. When using a data form to enter data and I enter an invalid value
on the form field corresponding to one of those cells I receive the
validation error dialogue that prompts me to retry. I enter the correct data
into that field on the form then close the form. My worksheet only has the
data relating to the corrected field entered. All other data entered via the
form is not entered onto the worksheet.

Is this a bug in Excel 2007? I previously was using Excel 2002 and found
that when using a data form in that version, the data validation did not
apply and only worked when entering data directly into the cdells on the
worksheet.

Has anyone else come across this problem?
--
Peter WA