Data Validation

K

Kosta S

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?
 
A

Anne Troy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top