There are instructions here for using a list from another workbook:

http://www.contextures.com/xlDataVal05.html

The other workbook must be open. This is the same in Excel 2000 and
Excel 2003.

Kosta S wrote:
I am trying to use the drop down list one Excel2003 but doesnt seam to work.
My date is in another workbook and when I am trying to validate This Error
comes up €œYou may not use references to other worksheets or workbooks for
Data Validation Criteria.
I am doing the same thing on my other computer that has Excel 2000 an I do
not have any problem In fact if I create the two workbooks on Excel 2000 they
work fine on Excel 2003 van you help me with this issue.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html