i followed the directions to create a drop down list on one workbook with
criteria from another workbook with data validation (as the directions stated
from the help section"Create a drop-down list from a range of cells "). when
i enter the name of the reference (=ValidDepts), i get an error message that
says, "you may not use references to other worksheets or workbooks for data
validation criteria." can someone help me with this?

Much Thanks