Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Validation dos not work
I am trying to use the drop down list one Excel2003 but doesnt seam to work.
My date is in another workbook and when I am trying to validate This Error comes up €œYou may not use references to other worksheets or workbooks for Data Validation Criteria. I am doing the same thing on my other computer that has Excel 2000 an I do not have any problem In fact if I create the two workbooks on Excel 2000 they work fine on Excel 2003 van you help me with this issue. Thank you Kosta -- KS |
#2
|
|||
|
|||
Can you place formulas in the workbook where you WANT the validation that
directly reference the cells in the workbook containing your validation list, then use the range of formulas in the Data | VAlidation | Source? Seems to work in the simple test I just did Duke "Kosta S" wrote in message ... I am trying to use the drop down list one Excel2003 but doesn't seam to work. My date is in another workbook and when I am trying to validate This Error comes up "You may not use references to other worksheets or workbooks for Data Validation Criteria. I am doing the same thing on my other computer that has Excel 2000 an I do not have any problem In fact if I create the two workbooks on Excel 2000 they work fine on Excel 2003 van you help me with this issue. Thank you Kosta -- KS |
#3
|
|||
|
|||
Yes in the same workbokk works but dos not work if the date is in another
workbook. "Duke Carey" wrote: Can you place formulas in the workbook where you WANT the validation that directly reference the cells in the workbook containing your validation list, then use the range of formulas in the Data | VAlidation | Source? Seems to work in the simple test I just did Duke "Kosta S" wrote in message ... I am trying to use the drop down list one Excel2003 but doesn't seam to work. My date is in another workbook and when I am trying to validate This Error comes up "You may not use references to other worksheets or workbooks for Data Validation Criteria. I am doing the same thing on my other computer that has Excel 2000 an I do not have any problem In fact if I create the two workbooks on Excel 2000 they work fine on Excel 2003 van you help me with this issue. Thank you Kosta -- KS |
#4
|
|||
|
|||
Debra Dalgleish has some notes at:
http://www.contextures.com/xlDataVal05.html Kosta S wrote: Yes in the same workbokk works but dos not work if the date is in another workbook. "Duke Carey" wrote: Can you place formulas in the workbook where you WANT the validation that directly reference the cells in the workbook containing your validation list, then use the range of formulas in the Data | VAlidation | Source? Seems to work in the simple test I just did Duke "Kosta S" wrote in message ... I am trying to use the drop down list one Excel2003 but doesn't seam to work. My date is in another workbook and when I am trying to validate This Error comes up "You may not use references to other worksheets or workbooks for Data Validation Criteria. I am doing the same thing on my other computer that has Excel 2000 an I do not have any problem In fact if I create the two workbooks on Excel 2000 they work fine on Excel 2003 van you help me with this issue. Thank you Kosta -- KS -- Dave Peterson |
#5
|
|||
|
|||
There are instructions here for using a list from another workbook:
http://www.contextures.com/xlDataVal05.html The other workbook must be open. This is the same in Excel 2000 and Excel 2003. Kosta S wrote: I am trying to use the drop down list one Excel2003 but doesnt seam to work. My date is in another workbook and when I am trying to validate This Error comes up €œYou may not use references to other worksheets or workbooks for Data Validation Criteria. I am doing the same thing on my other computer that has Excel 2000 an I do not have any problem In fact if I create the two workbooks on Excel 2000 they work fine on Excel 2003 van you help me with this issue. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#6
|
|||
|
|||
Hi Dave,
Thank you, I am lookin at that information and Iwill let you know "Dave Peterson" wrote: Debra Dalgleish has some notes at: http://www.contextures.com/xlDataVal05.html Kosta S wrote: Yes in the same workbokk works but dos not work if the date is in another workbook. "Duke Carey" wrote: Can you place formulas in the workbook where you WANT the validation that directly reference the cells in the workbook containing your validation list, then use the range of formulas in the Data | VAlidation | Source? Seems to work in the simple test I just did Duke "Kosta S" wrote in message ... I am trying to use the drop down list one Excel2003 but doesn't seam to work. My date is in another workbook and when I am trying to validate This Error comes up "You may not use references to other worksheets or workbooks for Data Validation Criteria. I am doing the same thing on my other computer that has Excel 2000 an I do not have any problem In fact if I create the two workbooks on Excel 2000 they work fine on Excel 2003 van you help me with this issue. Thank you Kosta -- KS -- Dave Peterson |
#7
|
|||
|
|||
Hi Debra and Dave.
Thank you, I was fallowing the instructions that was provided on the help from Excel and the way you point to the other book on the validations procedure is by going to "window" and then click to the workbook you want to use as your source if you fallow that procedure inserts [ ] brackets around the workbook and I believe that was my problem Kosta "Debra Dalgleish" wrote: There are instructions here for using a list from another workbook: http://www.contextures.com/xlDataVal05.html The other workbook must be open. This is the same in Excel 2000 and Excel 2003. Kosta S wrote: I am trying to use the drop down list one Excel2003 but doesnt seam to work. My date is in another workbook and when I am trying to validate This Error comes up €œYou may not use references to other worksheets or workbooks for Data Validation Criteria. I am doing the same thing on my other computer that has Excel 2000 an I do not have any problem In fact if I create the two workbooks on Excel 2000 they work fine on Excel 2003 van you help me with this issue. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation doesn't work on 1 sheet only | Excel Discussion (Misc queries) | |||
Data Validation Window? | Excel Discussion (Misc queries) | |||
Validation list behaving strangely in 2003 | Excel Worksheet Functions | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
Change Path names in copied work book | Excel Worksheet Functions |