Manage Relationships Dialog Box

The Manage Relationships dialog box enables you to view or edit the relationships in PowerPivot data, to delete one or more relationships, or to create a new relationship. To access this dialog box, on the Design tab, in the Relationships group, click Manage Relationships.

For more information about what a relationship is and how creating relationships can help you create more useful data models, see Relationships Overview.

Note
When you add, modify, or delete a relationship between tables, the workbook may need to be recalculated. If formulas in the workbook used columns that depended on the relationship, the formulas may return an error after the relationship is changed. For more information about recalculation, see Recalculate Formulas.