drop down list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a drop down list that references another workbook. I
found the instructions on how to do this in the Excel help guide. However,
when i follow the directions to do so, i receive an error that says you
cannot reference another workbook when validating data. can anyone help me
with this?
 
under data validation choose list
a formula similar to this will work:

=INDIRECT("[Book3]Sheet1!$A$1:$A$19"
 
there isnt a way to do it without having to have the other file open is there?
 
not that I know of. you can create a macro to open the second sheet and
hide it as the first is opened, but that would involve the user having
to enable macros everytime they opened the sheet.
 
You must log in or register to reply here.

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

create drop down list from different workbook 2
Filtered drop down list 2
Drop Down List Contains the List Header Row 1
problem with drop down lists 1
Creating a List 4
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Drop Down List + Validation 1
Drop-down lists in Excel 2003 3

Back
Top