After creating the relationship, Excel will identify those tables as a Data Model Table, not a Worksheet Table in the dropdowns. To see what Excel did, click Manage Data Model in the Data Tools group.

Consider the following Excel worksheet with two tables in it, called Dimension and Fact: If you were to load these two tables into the Excel Data Model, you would probably want to create a ...