Excel 2003 using a list from another workbook

  • Thread starter Thread starter Kimberly
  • Start date Start date
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
 
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
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6
Create a drop-down list from a range of cell 4
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Pop up menus in cells fed by lists in another workbook 3
Data/Validate/List 1
Excel: Use a name with external workbook reference for data valida 3

Back
Top