Export (0) Print
Expand All

Detecting and Creating Relationships Dialog Box

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

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.

Note Note

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.

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

Community Additions

ADD
Show:
© 2015 Microsoft