I just opened up one of my workbooks built in Excel 2003 and all the data validation seems to work OK in 2007. The 3 types I checked were list, whole numbers, and dates.

Which type if DV was not working for you?

Ron