Validation dos not work

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

Guest

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
 
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
 
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
 
Back
Top