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 |
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 |
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 |
All times are GMT +1. The time now is 01:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com