Drop Down list from another workbook

Hi,

I would like to create a drop down list for a workbook that has the master lists in a different workbook. I'm working with Excel 2010.

I have tried naming the range and in the source field typing =HOMEPOSITION but to now avail.

TIA!

hi,

I believe the list have to be in same workbook (can be different sheet) to work.

Reg,
CVishu