Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 using a list from another workbook
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - I can't maximize my workbook | Excel Discussion (Misc queries) | |||
Unprotecting a Workbook in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 Workbook into Word 2003 | Excel Discussion (Misc queries) | |||
Saving a workbook in Excel 2003 | Excel Discussion (Misc queries) | |||
Why do I get a warning when I try to save an Excel 2003 workbook. | Excel Discussion (Misc queries) |