Stuck...

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