Prob in creating dropdown in excel

while creating drop down in a workbook,when i tried to link it with another workbook via data->
validation,it shows :”u may not use references to other worksheets or workbooks for data validation rules.”I m using Office 2003.