Verify the column in one of the tables has unique data values with no duplicates.
Give each table a meaningful name: In Table Tools, click Design > Table Name > enter a name. Make sure the workbook contains at least two tables, and that each table has a column that can be mapped to a column in another table.ĭo one of the following: Format the data as a table, or Import external data as a table in a new worksheet. For all other cases, you’ll need to create relationships manually. When you import related tables from a relational database, Excel can often create those relationships in the Data Model it’s building behind the scenes.
