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.
