Tap into the power of data validation in Excel (free PDF) (TechRepublic) You can’t create a relationship between ordinary data sets. The Data Model works only with Table objects. The example ...

Although you don't have to format your data as an Excel table, doing so will make life easier if you add more rows or columns, and Excel generally reads data formatted as a table ...