Useing excel 2000 I am able to use a list from one workbook for a dropdown
list in another workbook with no problems, however after upgrading to Office
2003 I can no longer do this. Why?? I tryed to look in the options for a
setting that my affect it but nothing stood out as the solution.

If that feature worked in Excel 2000, it should still work in Excel
2003. Are both workbooks open?

There are instructions here for creating a data validation list based on
a list in a different workbook. Did you create something similar?

http://www.contextures.com/xlDataVal05.html

Catfish25 wrote:
Useing excel 2000 I am able to use a list from one workbook for a dropdown
list in another workbook with no problems, however after upgrading to Office
2003 I can no longer do this. Why?? I tryed to look in the options for a
setting that my affect it but nothing stood out as the solution.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

"Debra Dalgleish" wrote:

If that feature worked in Excel 2000, it should still work in Excel
2003. Are both workbooks open?

There are instructions here for creating a data validation list based on
a list in a different workbook. Did you create something similar?

http://www.contextures.com/xlDataVal05.html

Catfish25 wrote:
Useing excel 2000 I am able to use a list from one workbook for a dropdown
list in another workbook with no problems, however after upgrading to Office
2003 I can no longer do this. Why?? I tryed to look in the options for a
setting that my affect it but nothing stood out as the solution.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

both are open. I've ceated these dropdowns many time but this is the firs time that i tried it in 2003 and I recive a message that i may not referance a list in another workbook for data validations