Data Validation in another workbook (again)

**blacque** · 04-07-2009, 06:57 PM

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..

**mubashir aziz** · 04-08-2009, 12:01 AM

you can attach sample file to see the problem unless its hard to guess ...

**blacque** · 04-08-2009, 12:05 PM

Thank you for your reply Aziz

Ok, this is the sample..

**mubashir aziz** · 04-09-2009, 05:17 AM

Here we go ..... find attached file with option 1 & Option 2 ..... hope it will solve the problem ....

**blacque** · 04-09-2009, 06:09 AM

Waw, thank you very much Aziz! my problem has solved

By the way, I also kept look for the solution, and finally I got this url:

http://excel.tips.net/Pages/T002813_...alidation.html

And this was also helped my problem. See the attached file.. This solution is like Aziz's. This is just the alternative..

Hope this will help everyone too