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 datavalidation 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
workbook


Regards,

Peo Sjoblom



"Mike" wrote:

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

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



"Mike" wrote:

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

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

"Peo Sjoblom" wrote:

1. If you mean datavalidation 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
workbook


Regards,

Peo Sjoblom



"Mike" wrote:

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

Here's an example

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


Regards,


Peo Sjoblom


"Mike" wrote:

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

"Peo Sjoblom" wrote:

1. If you mean datavalidation 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
workbook


Regards,

Peo Sjoblom



"Mike" wrote:

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