Validation
 

At the data Validation dialogue box when I am entering the €œ=ID€� that what I
Define my data name I gate this error €œYou may not use references to other
worksheets or workbooks for data validation criteria€� this is only happening
on my 2003 excel. I have open two workbooks in the seam directory one called
Test1 and this is where the data validation accurse and where the data is
stored I called Tes2 I have no problem with excel 2000.

Is some thing of?

with 2000
I do not have the result you said.

Obliged to use use a reference on the same sheet

My problem is with 2003 not with the 2002

"abcd" wrote:

with 2000
I do not have the result you said.

Obliged to use use a reference on the same sheet

Hi ABCD.

Obliged to use use a reference on the same sheet

To use a list on another sheet, name the list and use that name in the data
validation source box.

To use a list in another workbook, add a defined name which refers to the
other workbook list. Use the defined name in the datavalidation source.

---
Regards,
Norman



"abcd" wrote in message
...
with 2000
I do not have the result you said.

Obliged to use use a reference on the same sheet

Hi Kosta,

If your named list range is ID, try using:

=ID

in the data validation source book -without the quotation marks.


---
Regards,
Norman



"Kosta" wrote in message
...
At the data Validation dialogue box when I am entering the "=ID" that
what I
Define my data name I gate this error "You may not use references to other
worksheets or workbooks for data validation criteria" this is only
happening
on my 2003 excel. I have open two workbooks in the seam directory one
called
Test1 and this is where the data validation accurse and where the data is
stored I called Tes2 I have no problem with excel 2000.

Is some thing of?

I have done that in both versions I hove no problem with excel 2000 I have a
problem with excel 2003 and specifically when I am €œData validation€� at
source box if I enter €œ=ID€� donor excepted give this error €œYou may not use
references to other worksheets or workbooks for data validation criteria€�.


"Norman Jones" wrote:

Hi ABCD.

Obliged to use use a reference on the same sheet

To use a list on another sheet, name the list and use that name in the data
validation source box.

To use a list in another workbook, add a defined name which refers to the
other workbook list. Use the defined name in the datavalidation source.

---
Regards,
Norman



"abcd" wrote in message
...
with 2000
I do not have the result you said.

Obliged to use use a reference on the same sheet

I have done that in both versions I hove no problem with excel 2000 I have a
problem with excel 2003 and specifically when I am €œData validation€� at
source box if I enter €œ=ID€� donor excepted give this error €œYou may not use
references to other worksheets or workbooks for data validation criteria€�.

"Norman Jones" wrote:

Hi ABCD.

Obliged to use use a reference on the same sheet

To use a list on another sheet, name the list and use that name in the data
validation source box.

To use a list in another workbook, add a defined name which refers to the
other workbook list. Use the defined name in the datavalidation source.

---
Regards,
Norman



"abcd" wrote in message
...
with 2000
I do not have the result you said.

Obliged to use use a reference on the same sheet

As I mentioned before it works on 2000 and doesnt work on 2003 I am not
using quotation marks. This my question do you thing I have a problem with my
2003 excel i.e. is not installed properly or do I have to do something else
like on the option menu.

"Norman Jones" wrote:

Hi Kosta,

If your named list range is ID, try using:

=ID

in the data validation source book -without the quotation marks.


---
Regards,
Norman



"Kosta" wrote in message
...
At the data Validation dialogue box when I am entering the "=ID" that
what I
Define my data name I gate this error "You may not use references to other
worksheets or workbooks for data validation criteria" this is only
happening
on my 2003 excel. I have open two workbooks in the seam directory one
called
Test1 and this is where the data validation accurse and where the data is
stored I called Tes2 I have no problem with excel 2000.

Is some thing of?

Did you create a range name in the other workbook?

Then did you create a name in the workbook that used that other workbook's
name--or did you use the address?

I created a name in book2.xls
myID
that pointed to: =Sheet1!$A$1:$A$11
in book2.xls

Then in book1.xls, I created a name:
myID
that pointed to: =Book2.xls!myID

(I changed the name to myID for no real reason except I don't like short names!)

And Data|Validation worked ok inside book1.xls.

As far as I remember xl97 and xl2k and xl2002 all worked the same way.

Debra Dalgleish has some nice instructions (with pictures) at:
http://contextures.com/xlDataVal05.html

Kosta wrote:

At the data Validation dialogue box when I am entering the €œ=ID€� that what I
Define my data name I gate this error €œYou may not use references to other
worksheets or workbooks for data validation criteria€� this is only happening
on my 2003 excel. I have open two workbooks in the seam directory one called
Test1 and this is where the data validation accurse and where the data is
stored I called Tes2 I have no problem with excel 2000.

Is some thing of?

--

Dave Peterson

Thank you Dave.

I have done all that if I create the two files on 2000 and then copy them on
2003 they work fine I just cont do it on the 2003 version at this machine I
am going to tried to another machine that has excel 2003 and see if I have
the same problem

I will let you know.

By the way thanks to Norman also he was trying to help me before.


"Dave Peterson" wrote:

Did you create a range name in the other workbook?

Then did you create a name in the workbook that used that other workbook's
name--or did you use the address?

I created a name in book2.xls
myID
that pointed to: =Sheet1!$A$1:$A$11
in book2.xls

Then in book1.xls, I created a name:
myID
that pointed to: =Book2.xls!myID

(I changed the name to myID for no real reason except I don't like short names!)

And Data|Validation worked ok inside book1.xls.

As far as I remember xl97 and xl2k and xl2002 all worked the same way.

Debra Dalgleish has some nice instructions (with pictures) at:
http://contextures.com/xlDataVal05.html

Kosta wrote:

At the data Validation dialogue box when I am entering the €œ=ID€� that what I
Define my data name I gate this error €œYou may not use references to other
worksheets or workbooks for data validation criteria€� this is only happening
on my 2003 excel. I have open two workbooks in the seam directory one called
Test1 and this is where the data validation accurse and where the data is
stored I called Tes2 I have no problem with excel 2000.

Is some thing of?

--

Dave Peterson

I use xl2003, also.

If I used a name in the first workbook, and referred to that name in the name in
the other workbook (whew!), then the Data|Validation worked fine.

If I just used a name that referred to a range ($a$1:$a$10) in another worksheet
in another workbook, then it failed.

I guess I'm saying that I'd double check those name definitions.

Kosta wrote:

Thank you Dave.

I have done all that if I create the two files on 2000 and then copy them on
2003 they work fine I just cont do it on the 2003 version at this machine I
am going to tried to another machine that has excel 2003 and see if I have
the same problem

I will let you know.

By the way thanks to Norman also he was trying to help me before.

"Dave Peterson" wrote:

Did you create a range name in the other workbook?

Then did you create a name in the workbook that used that other workbook's
name--or did you use the address?

I created a name in book2.xls
myID
that pointed to: =Sheet1!$A$1:$A$11
in book2.xls

Then in book1.xls, I created a name:
myID
that pointed to: =Book2.xls!myID

(I changed the name to myID for no real reason except I don't like short names!)

And Data|Validation worked ok inside book1.xls.

As far as I remember xl97 and xl2k and xl2002 all worked the same way.

Debra Dalgleish has some nice instructions (with pictures) at:
http://contextures.com/xlDataVal05.html

Kosta wrote:

At the data Validation dialogue box when I am entering the €œ=ID€� that what I
Define my data name I gate this error €œYou may not use references to other
worksheets or workbooks for data validation criteria€� this is only happening
on my 2003 excel. I have open two workbooks in the seam directory one called
Test1 and this is where the data validation accurse and where the data is
stored I called Tes2 I have no problem with excel 2000.

Is some thing of?

--

Dave Peterson


--

Dave Peterson