Validation dos not work
 

I am trying to use the drop down list one Excel2003 but doesnt 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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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 doesnt 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" wrote in message
...
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 doesnt 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