Hello

Ok I followed the instructions on the Help to create a dop down using a list
of entries located in another workbook, but when I get to Step 6 that says to
enter the name of the workbook with an equal sign, I get an error that reads:

You may not use references to other worksheets or workbooks for Data
Validation criteria.

Any insight into this problem would be appreciated.

thanks!

Try create a defined name of ur range, then use this name in DV

"Natalya" skrev:

> Hello
>
> Ok I followed the instructions on the Help to create a dop down using a list
> of entries located in another workbook, but when I get to Step 6 that says to
> enter the name of the workbook with an equal sign, I get an error that reads:
>
> You may not use references to other worksheets or workbooks for Data
> Validation criteria.
>
> Any insight into this problem would be appreciated.
>
> thanks!

There are instructions here that might help you:

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

Natalya wrote:
> Hello
>
> Ok I followed the instructions on the Help to create a dop down using a list
> of entries located in another workbook, but when I get to Step 6 that says to
> enter the name of the workbook with an equal sign, I get an error that reads:
>
> You may not use references to other worksheets or workbooks for Data
> Validation criteria.
>
> Any insight into this problem would be appreciated.
>
> thanks!


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com