Export (0) Print
Expand All

Manage Relationships Dialog Box

Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on Office.com.

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

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft