I am trying to create a drop down list.
i have a spreadsheet with the list of the values i want in the drop down
menu in an other workbook
i have followed the instruction of:
http://office.microsoft.com/en-us/ex...022151033.aspx
but when i try to insert the drop down list i get an error msg.
in the final work book i went to Data/Validation, i have select List from
allow window but when i try to define the actual list i need from an another
workbook the message that appears is:
"you may not use references to other worksheets or workbooks for Data
Validation criteria"
what do i do wrong?
thanks in advance