Detecting and Creating Relationships Dialog Box
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.