software

How do I link to (and be able to choose data from) a drop list in another
workbook?
Every time I try to type in the path, an error message says its not allowed.
Is there
a way around this problem?
Thanks for any help....

1. If you mean datagt;validation you need to name the list in the other workbook.
2. The other workbook needs to be open, you cannot use a list from a closed
workbookRegards,

Peo Sjoblom
quot;Mikequot; wrote:

gt; How do I link to (and be able to choose data from) a drop list in another
gt; workbook?
gt; Every time I try to type in the path, an error message says its not allowed.
gt; Is there
gt; a way around this problem?
gt; Thanks for any help....

You can link the Validation list in from a closed workbook to a helper list
in this workbook, using formulas like this...

='C:\[Book1.xls]Sheet1'!$D7
='C:\[Book1.xls]Sheet1'!$D8
='C:\[Book1.xls]Sheet1'!$D9.....etc etc

and then set up the Data Validation on the local list.........

hth
Vaya con Dios,
Chuck, CABGx3
quot;Mikequot; wrote:

gt; How do I link to (and be able to choose data from) a drop list in another
gt; workbook?
gt; Every time I try to type in the path, an error message says its not allowed.
gt; Is there
gt; a way around this problem?
gt; Thanks for any help....

Thanks for the reply.... I have done both steps but
I still get the error message quot;You may not use references to other
worksheets or workbooks for data validation criteriaquot;.
What have I missed?
Thanks again, Mike.

quot;Peo Sjoblomquot; wrote:

gt; 1. If you mean datagt;validation you need to name the list in the other workbook.
gt; 2. The other workbook needs to be open, you cannot use a list from a closed
gt; workbook
gt;
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt;
gt;
gt; quot;Mikequot; wrote:
gt;
gt; gt; How do I link to (and be able to choose data from) a drop list in another
gt; gt; workbook?
gt; gt; Every time I try to type in the path, an error message says its not allowed.
gt; gt; Is there
gt; gt; a way around this problem?
gt; gt; Thanks for any help....

Here's an example

www.contextures.com/xlDataVal05.htmlRegards,Peo Sjoblomquot;Mikequot; wrote:

gt; Thanks for the reply.... I have done both steps but
gt; I still get the error message quot;You may not use references to other
gt; worksheets or workbooks for data validation criteriaquot;.
gt; What have I missed?
gt; Thanks again, Mike.
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt; gt; 1. If you mean datagt;validation you need to name the list in the other workbook.
gt; gt; 2. The other workbook needs to be open, you cannot use a list from a closed
gt; gt; workbook
gt; gt;
gt; gt;
gt; gt; Regards,
gt; gt;
gt; gt; Peo Sjoblom
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Mikequot; wrote:
gt; gt;
gt; gt; gt; How do I link to (and be able to choose data from) a drop list in another
gt; gt; gt; workbook?
gt; gt; gt; Every time I try to type in the path, an error message says its not allowed.
gt; gt; gt; Is there
gt; gt; gt; a way around this problem?
gt; gt; gt; Thanks for any help....