T
Terry
In Excel 2003, I'm trying to create a validation drop down
list and populate the list from another workbook. There
are a number of articles in Excel help that provide
instructions for doing this, however when I try it I get
the following error: You may not use references to other
worksheets or workbooks for Data Validation criteria.
When I try the same thing with Excel in Office XP it works
fine.
Any help or tips would be greatly appreciated.
Terry
list and populate the list from another workbook. There
are a number of articles in Excel help that provide
instructions for doing this, however when I try it I get
the following error: You may not use references to other
worksheets or workbooks for Data Validation criteria.
When I try the same thing with Excel in Office XP it works
fine.
Any help or tips would be greatly appreciated.
Terry