drop list from a different workbook,

[myquest]

I followed instructions in www.contextures.com/xlData Val05.html and I get
the same error. You cannot use a range from another workbook - help!

[Ron de Bruin]

Have you read this

For data validation to work, the workbook which contains the list must be open. You could create the list in a workbook that is
always open, but hidden, such as the Personal.xls workbook.


--
Regards Ron de Bruin
http://www.rondebruin.nl


"myquest" <myquest@discussions.microsoft.com> wrote in message news:72CF45E8-1D60-410A-9DE9-7CFC92B980D1@microsoft.com...
>I followed instructions in www.contextures.com/xlData Val05.html and I get
> the same error. You cannot use a range from another workbook - help!

[myquest]

Yes, I tried creating a completely new workbook and keeping it open.
Same thing - I named the range with my list; I went to my first wrkbook and
defined a name using the other workbk name and then the name. Then at Data -
validation - source I put that name. I always get the same error.

"Ron de Bruin" wrote:

> Have you read this
>
> For data validation to work, the workbook which contains the list must be open. You could create the list in a workbook that is
> always open, but hidden, such as the Personal.xls workbook.
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "myquest" <myquest@discussions.microsoft.com> wrote in message news:72CF45E8-1D60-410A-9DE9-7CFC92B980D1@microsoft.com...
> >I followed instructions in www.contextures.com/xlData Val05.html and I get
> > the same error. You cannot use a range from another workbook - help!
>
>
>

[Ron de Bruin]

Follow Debra's steps again and you will see that it is working

--
Regards Ron de Bruin
http://www.rondebruin.nl


"myquest" <myquest@discussions.microsoft.com> wrote in message news:74F718E9-99A5-4B93-BA80-B1240F4EF103@microsoft.com...
> Yes, I tried creating a completely new workbook and keeping it open.
> Same thing - I named the range with my list; I went to my first wrkbook and
> defined a name using the other workbk name and then the name. Then at Data -
> validation - source I put that name. I always get the same error.
>
> "Ron de Bruin" wrote:
>
>> Have you read this
>>
>> For data validation to work, the workbook which contains the list must be open. You could create the list in a workbook that is
>> always open, but hidden, such as the Personal.xls workbook.
>>
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>> "myquest" <myquest@discussions.microsoft.com> wrote in message news:72CF45E8-1D60-410A-9DE9-7CFC92B980D1@microsoft.com...
>> >I followed instructions in www.contextures.com/xlData Val05.html and I get
>> > the same error. You cannot use a range from another workbook - help!
>>
>>
>>

[myquest]

You are quite right; If I use her exact range names and workbook name it
works but not with mine! I was using PartsBook.xls and the range name was
PartList. Very strange but I must be making a silly mistake - more coffee.
Thanks

"Ron de Bruin" wrote:

> Follow Debra's steps again and you will see that it is working
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "myquest" <myquest@discussions.microsoft.com> wrote in message news:74F718E9-99A5-4B93-BA80-B1240F4EF103@microsoft.com...
> > Yes, I tried creating a completely new workbook and keeping it open.
> > Same thing - I named the range with my list; I went to my first wrkbook and
> > defined a name using the other workbk name and then the name. Then at Data -
> > validation - source I put that name. I always get the same error.
> >
> > "Ron de Bruin" wrote:
> >
> >> Have you read this
> >>
> >> For data validation to work, the workbook which contains the list must be open. You could create the list in a workbook that is
> >> always open, but hidden, such as the Personal.xls workbook.
> >>
> >>
> >> --
> >> Regards Ron de Bruin
> >> http://www.rondebruin.nl
> >>
> >>
> >> "myquest" <myquest@discussions.microsoft.com> wrote in message news:72CF45E8-1D60-410A-9DE9-7CFC92B980D1@microsoft.com...
> >> >I followed instructions in www.contextures.com/xlData Val05.html and I get
> >> > the same error. You cannot use a range from another workbook - help!
> >>
> >>
> >>
>
>
>