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
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 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
if condition with data validation list 5

Top