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

Yes, the data form in Excel 2007 wipes out all the data in columns 
before the data validation error column.

You could try John Walkenbach's free enhanced Data Entry form for Excel 
2007. It seems to ignore the data validation rules, and enter all the data.

http://spreadsheetpage.com/index.php/dataform/home


Peter wrote:
> 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?


-- 
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com