Detecting and Creating Relationships Dialog Box

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

The Detecting and Creating dialog box presents information about new relationships that are created automatically when you add new fields in a PivotTable or PivotChart. To access this dialog box, in the PowerPivot Field List, add a field from a table that is not already related to a table in the PivotTable, and then click Create when Relationship may be needed is displayed.

The process consists of two steps:

  • Detection of relationships

  • Creation of the relationships

When there are many fields in the PivotTable that might be related, the process of analysis can take a long time. You can cancel the detection process, but you cannot cancel the creation process.


The algorithm for automatic detection of relationships takes into account the data type of the field, and other factors such as the number of values and distinct values, field names, etc. For more information about the heuristics used for automatic detection, see Relationships Overview.

  • Status
    Displays the status of analysis.

    Click the Details link at the right side of the Status area to open the Relationship Details dialog box and view information about warnings or errors that were raised after detection. For example, if no relationships were created, the Relationship Details report provides more information about the reason that detection failed.

  • Work item
    Shows the status of the detection operation.

  • Summary
    Click the link to view information about any new relationships that were created.

    If detection was successful, the information in the Relationship Details report lists the new relationships that were created, including the columns and tables that were joined.

  • Close
    Click to exit the dialog box and return to the Excel PivotTable area.

See Also


Take a Tour of the PowerPivot UI

Relationships Overview