Add relationships to Data Model in PowerPivot

You can systematically create table relationships for all new tables that you import. If you’re sharing the workbook with colleagues, having predefined relationships will be appreciated if they don’t know the data as well as you do. When creating relationships manually, you will work with two tables at a time. For each table, you’ll choose… More Add relationships to Data Model in PowerPivot