How to create a drop down menu which referencing a different workb

G

Guest

I followed the Microsoft Help instruction to create drop down list. It says
i can create a drop down list in separete worksheet or different workbook.
but only the separate worksheet seems to work. I tried to link my drop down
menu to different workbook and it shows this error message "You may not use
reference to other worksheets or workbook for data validation criteria".
what does it mean? how can i create a drop down menu and link it to a
different workbook?

Joanne
 

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

Drop Down Menu 4
Drop down List w/ Values Pop Automacailly when choose entry from l 8
Drop Down List Contains the List Header Row 1
create drop down list from different workbook 2
lost the drop down list (the validation still exist) 4
Drop-down menu and additional sheets 4
Creating drop downs in a cell contingent on another drop down 1
drop down menu color 1

Top