Validation

[Kosta]

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?

 

[abcd]

with 2000
I do not have the result you said.

Obliged to use use a reference on the same sheet

 

[Kosta]

My problem is with 2003 not with the 2002

 

[Norman Jones]

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.

 

[Norman Jones]

Hi Kosta,

If your named list range is ID, try using:

=ID

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

 

[Kosta]

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â€.

 

[Kosta]

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â€.

 

[Kosta]

As I mentioned before it works on 2000 and doesn’t 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.

 

[Dave Peterson]

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]

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]

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.