Source for DropDown in another workbook

  • Thread starter alexis_anne3799
  • Start date
A

alexis_anne3799

Hi. I created a dropdown list in one workbook (Workbook 1) and the data
source is found in another workbook (Workbook 2). How do I make sure that
even if Workbook 2 is not open, the dropdown lists in Workbook 1 will still
display the items on the list?

Thanks!
 
A

Alan

alexis_anne3799 said:
Hi. I created a dropdown list in one workbook (Workbook 1) and the data
source is found in another workbook (Workbook 2). How do I make sure that
even if Workbook 2 is not open, the dropdown lists in Workbook 1 will still
display the items on the list?

Thanks!

why not just copy it into workbook 1?
 
G

Gord Dibben

Quote from Debra Dalgleish's site on DV

For data validation to work, the workbook which contains the list must be open,
in the same instance of Excel. You could create the list in a workbook that is
always open, but hidden, such as the Personal.xls workbook.

End quote.........


Gord Dibben MS Excel MVP
 
A

alexis_anne3799

Thanks Gord. Follow-up question on that...
How do I keep the source workbook as "always open and hidden" in the same
instance? I'm a novice, so I hope you can spell it out for me step-by-step.
Thanks again. Much appreciated...
 

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

Top