Excel 2003 using a list from another workbook
Hi Kimberley
No, it works fine in XL2003.
I suspect you are not following Debra's instructions completely, especially
points 4 and 5
4. Keep MyLists.xls open, and create and save a new workbook (Schedule.xls)
5. In Schedule.xls, create a range named EmployeeList with this formula:
=MyLists.xls!Employees
--
Regards
Roger Govier
"Kimberly" wrote in message
...
Everytime I follow Debra's directions in "Use a List from Another
Workbook"
I get an error message that "You may not use references to other
worksheets
or workbooks for data validation criteria". Does it just not work in
2003?
Thanks.
Kimberly
|