How to show dropdown list from another workbook without running it

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

Guest

I created a dropdown list using as a source a column from another
spreadsheet. When I colose the source spreadsheet the dropdown list doesn't
work anymore.
Any idea?
 
Copy the choices for the drop down to the main workbook..
If you don't like seeing them in the main workboook, put them on another
worksheet and hide that worksheet..
 
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

Dropdown list from another spreadsheet doesn't work if close sourc 1
dropdown list determined by another dropdown list 5
Data Source for Dropdown Lists 6
Combobox dropdown list??????????? 3
in-cell dropdown menus 2
Can a dropdown box reference to another workbook? 4
Displaying arrow in a dropdown list within cell 2
Data validation with dropdown list 2

Back
Top