Validation dos not work

I am trying to use the drop down list one Excel2003 but doesn’t seam to work.
My date is in another workbook and when I am trying to validate This Error
comes up “You may not use references to other worksheets or workbooks for
Data Validation Criteria.
I am doing the same thing on my other computer that has Excel 2000 an I do
not have any problem In fact if I create the two workbooks on Excel 2000 they
work fine on Excel 2003 van you help me with this issue.

Thank you
Kosta

--
KS

Can you place formulas in the workbook where you WANT the validation that
directly reference the cells in the workbook containing your validation
list, then use the range of formulas in the Data | VAlidation | Source?

Seems to work in the simple test I just did

Duke

"Kosta S" <[email protected]> wrote in message
news:[email protected]...
>I am trying to use the drop down list one Excel2003 but doesn't seam to
>work.
> My date is in another workbook and when I am trying to validate This Error
> comes up "You may not use references to other worksheets or workbooks for
> Data Validation Criteria.
> I am doing the same thing on my other computer that has Excel 2000 an I do
> not have any problem In fact if I create the two workbooks on Excel 2000
> they
> work fine on Excel 2003 van you help me with this issue.
>
> Thank you
> Kosta
>
> --
> KS

Yes in the same workbokk works but dos not work if the date is in another
workbook.

"Duke Carey" wrote:

> Can you place formulas in the workbook where you WANT the validation that
> directly reference the cells in the workbook containing your validation
> list, then use the range of formulas in the Data | VAlidation | Source?
>
> Seems to work in the simple test I just did
>
> Duke
>
> "Kosta S" <[email protected]> wrote in message
> news:[email protected]...
> >I am trying to use the drop down list one Excel2003 but doesn't seam to
> >work.
> > My date is in another workbook and when I am trying to validate This Error
> > comes up "You may not use references to other worksheets or workbooks for
> > Data Validation Criteria.
> > I am doing the same thing on my other computer that has Excel 2000 an I do
> > not have any problem In fact if I create the two workbooks on Excel 2000
> > they
> > work fine on Excel 2003 van you help me with this issue.
> >
> > Thank you
> > Kosta
> >
> > --
> > KS
>
>
>

Debra Dalgleish has some notes at:
http://www.contextures.com/xlDataVal05.html



Kosta S wrote:
>
> Yes in the same workbokk works but dos not work if the date is in another
> workbook.
>
> "Duke Carey" wrote:
>
> > Can you place formulas in the workbook where you WANT the validation that
> > directly reference the cells in the workbook containing your validation
> > list, then use the range of formulas in the Data | VAlidation | Source?
> >
> > Seems to work in the simple test I just did
> >
> > Duke
> >
> > "Kosta S" <[email protected]> wrote in message
> > news:[email protected]...
> > >I am trying to use the drop down list one Excel2003 but doesn't seam to
> > >work.
> > > My date is in another workbook and when I am trying to validate This Error
> > > comes up "You may not use references to other worksheets or workbooks for
> > > Data Validation Criteria.
> > > I am doing the same thing on my other computer that has Excel 2000 an I do
> > > not have any problem In fact if I create the two workbooks on Excel 2000
> > > they
> > > work fine on Excel 2003 van you help me with this issue.
> > >
> > > Thank you
> > > Kosta
> > >
> > > --
> > > KS
> >
> >
> >

--

Dave Peterson

There are instructions here for using a list from another workbook:

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

The other workbook must be open. This is the same in Excel 2000 and
Excel 2003.

Kosta S wrote:
> I am trying to use the drop down list one Excel2003 but doesn’t seam to work.
> My date is in another workbook and when I am trying to validate This Error
> comes up “You may not use references to other worksheets or workbooks for
> Data Validation Criteria.
> I am doing the same thing on my other computer that has Excel 2000 an I do
> not have any problem In fact if I create the two workbooks on Excel 2000 they
> work fine on Excel 2003 van you help me with this issue.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hi Dave,

Thank you,

I am lookin at that information and Iwill let you know

"Dave Peterson" wrote:

> Debra Dalgleish has some notes at:
> http://www.contextures.com/xlDataVal05.html
>
>
>
> Kosta S wrote:
> >
> > Yes in the same workbokk works but dos not work if the date is in another
> > workbook.
> >
> > "Duke Carey" wrote:
> >
> > > Can you place formulas in the workbook where you WANT the validation that
> > > directly reference the cells in the workbook containing your validation
> > > list, then use the range of formulas in the Data | VAlidation | Source?
> > >
> > > Seems to work in the simple test I just did
> > >
> > > Duke
> > >
> > > "Kosta S" <[email protected]> wrote in message
> > > news:[email protected]...
> > > >I am trying to use the drop down list one Excel2003 but doesn't seam to
> > > >work.
> > > > My date is in another workbook and when I am trying to validate This Error
> > > > comes up "You may not use references to other worksheets or workbooks for
> > > > Data Validation Criteria.
> > > > I am doing the same thing on my other computer that has Excel 2000 an I do
> > > > not have any problem In fact if I create the two workbooks on Excel 2000
> > > > they
> > > > work fine on Excel 2003 van you help me with this issue.
> > > >
> > > > Thank you
> > > > Kosta
> > > >
> > > > --
> > > > KS
> > >
> > >
> > >
>
> --
>
> Dave Peterson
>

Hi Debra and Dave.

Thank you,
I was fallowing the instructions that was provided on the help from Excel
and the way you point to the other book on the validations procedure is by
going to "window" and then click to the workbook you want to use as your
source if you fallow that procedure inserts [ ] brackets around the workbook
and I believe that was my problem

Kosta


"Debra Dalgleish" wrote:

> There are instructions here for using a list from another workbook:
>
> http://www.contextures.com/xlDataVal05.html
>
> The other workbook must be open. This is the same in Excel 2000 and
> Excel 2003.
>
> Kosta S wrote:
> > I am trying to use the drop down list one Excel2003 but doesn’t seam to work.
> > My date is in another workbook and when I am trying to validate This Error
> > comes up “You may not use references to other worksheets or workbooks for
> > Data Validation Criteria.
> > I am doing the same thing on my other computer that has Excel 2000 an I do
> > not have any problem In fact if I create the two workbooks on Excel 2000 they
> > work fine on Excel 2003 van you help me with this issue.
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>