Delete Relationships

You can delete existing relationships by using the Manage Relationships dialog box. For information about how relationships are used in PowerPivot for Excel, see Understanding Relationships.

Note

In Windows Vista and Windows 7, features in the PowerPivot window are available on a ribbon, which is discussed in this topic. In Windows XP, features are available from a set of menus. If you are using Windows XP and want to see how the menu commands relate to the ribbon commands, see The PowerPivot UI in Windows XP.

To delete one or more relationships

  1. In the PowerPivot window, click the Design tab, and in the Relationships group, click Manage Relationships.

  2. In the Manage Relationships dialog box, select one or more relationships from the list.

    To select multiple relationships, hold down CTRL while you click each relationship.

  3. Click Delete Relationship.

  4. In the warning dialog box, verify that you want to delete the relationship, and then click OK.

  5. In the Manage Relationships dialog box, click Close.

Considerations for Deleting Relationships

Keep the following issues in mind when deciding whether to delete a relationship:

  • There is no way to undo the deletion of a relationship. You can re-create the relationship, but this action requires a complete recalculation of formulas in the workbook. Therefore, always check first before deleting a relationship that is used in formulas.

  • Deleting a relationship between two tables can cause errors in PivotTables or in formulas that reference these tables. PivotTable results can change in unexpected ways after a relationship is deleted.

  • The Data Analysis Expression (DAX) RELATED function uses the relationships between tables to look up related values in another table. It will return different results after the relationship is deleted. For more information, see the RELATED Function (DAX).

  • In addition to changing PivotTable and formula results, both the creation and deletion of relationships will cause the workbook to be recalculated, which can take some time.

See Also

Other Resources

Create a Relationship Between Two Tables

View and Edit Relationships

Troubleshoot Relationships

Understanding Relationships