Data Validation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

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

Similar Threads

Validation 10
Velidation 1
Data Validation Restriction Referencing other Workbook 1
Validation dos not work 6
Multiple data validation criteria? 1
if condition with data validation list 5
custom data validation on cells with data validation values 2
Data Validation Not Erroring with List 2

Back
Top