1. Don't put quotes.
2. Possibly, it's because you're using "ID", which could be an internal name
used by Excel, tho I'm not aware of it.
*******************
~Anne Troy

www.OfficeArticles.com


"Kosta S" 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?

--
KS