I am trying to create a drop down list that references another workbook. I
found the instructions on how to do this in the Excel help guide. However,
when i follow the directions to do so, i receive an error that says you
cannot reference another workbook when validating data. can anyone help me
with this?