data validations

C

Catfish25

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.
 
C

Catfish25

Debra Dalgleish said:
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



--
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
Click to expand...
 
Top