Excel 2003 using a list from another workbook

K

Kimberly

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
 
R

Roger Govier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation Restriction Referencing other Workbook 1
Create a drop-down list from a range of cells 2
Data/Validate/List 1
Create a drop-down list from a range of cell 4
link from one workbook to another workbook using a dropdown? 2
if condition with data validation list 5
drop-down list validation won't allow a different worksheet 4
external refs and dropdown validation 3

Top