Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data 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? -- KS |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
You've got a bunch of responses in to your post in .misc.
Kosta S 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? -- KS -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation screen size | Excel Discussion (Misc queries) | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions |