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 Understanding Relationships.

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 Recalculating Formulas.

  • New Relationship
    Click to open the Create Relationship Dialog Box.

  • Edit Relationship
    Select a relationship from the list of relationships and then click Edit Relationship to change the currently selected relationship.

    You can change the tables and column that are used in the relationship.

  • Delete Relationship
    Select a relationship from the list of relationships and then click Delete Relationship to delete the relationship.

See Also

Other Resources

Delete Relationships

Create a Relationship Between Two Tables

View and Edit Relationships

Take a Tour of the PowerPivot UI