In Excel, you can create a drop down Data Validation list, so it’s easy to enter valid items in a cell. Usually, the list of valid items is stored in the same workbook, but it’s possible to set up a drop down from a list in another workbook.
I used data validation including drop-down lists in the 2007 format of Excel. when i open the workbook in 2003 format, the validation does not work. Please assist in recifying this without having to redo the entire workbook.