Data Validation in another workbook (again)

[blacque]

Hi everyone,

I have a problem in creating data validation. I want to make 3 drop lists which are connected to each other (file1.xls for example). The sample is like the tutorial from Contextures:

http://www.contextures.com/xlDataVal02.html

The source of lists are from another excel file (file2.xls). The method is also from Contextures:

http://www.contextures.com/xlDataVal05.html

And then, when I tried this, the second drop list didn't show up according to the first drop list. But, if I put the source in the same workbook (in file1.xls), It could show up.

I think the problem is in the name box, but I don't know how to fix it. Can you guys help me? I really appreciate your help..