Reference Call
 

Hi,

I just have a small problem regarding reference call.

First Excel file has 2 sheets - 1st sheet has drop down Menu list that I
created based on formulas.

2nd sheet - has the field values populated as well as formulas.

When I move the 2nd sheet to another MS-Excel file, to reference a call back
to the 1st sheet, I don't see my drop down Menu field values now.

How do I reference the call (communicate) 2 different worksheets in 2
different files?