View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default 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