Excel Drop Down List Tutorial Pt 3

Another option when creating a drop down list is to store the list data in a separate workbook.

Doing so allows the list data to be used in a number of different workbooks.

If several users need the same drop down list, having the data centrally located not only makes it easier to update the list when necessary, but it also makes it easier to protect the list data from accidental or intentional changes.

To find out all the details, read this tutorial on creating a drop down list in Excel using data stored in a separate workbook.