Double click on pivot table not displaying all fields

[bquackenbush]

Strange (to me at least) behavior from double clicking on a cell with data in a pivot table. Hoping someone can give me some insight.

We're running Excel 2013 Professional on Windows 10 Enterprise.

I have a pivot table using the "data model" functionality (i.e. in order to make "Count Distinct" available). This pivot table's source is an Excel data table in the same worksheet. The source data table is linked to another data table (also in the same worksheet) using the "Data->Relationships" functionality. The table it is linked to is primary.

When I double click on a cell in the pivot table with a value, it opens up a new worksheet as expected showing the detail supporting the value in that cell. However, the new detail worksheet drops the two columns that are linked using the "Data->Relationships" functionality. Slicers that are attached to this pivot (which are based on the two fields that drop off) work fine and the two fields that drop off are listed and active in the pivot table field list (i.e. I can add them as page, row or column). However, even adding these fields to the page/filter does not force the fields to display when I double click a cell in the pivot table.

Below are the fields in the pivot table's source (data table in the same worksheet). These fields are available for use in the pivot table itself. The first two fields are the two that don't display when I double click a cell.

[$DETAIL].[SR Owner Full Name] <-- not showing when a cell is double clicked…linked to [$SR_OWNER].[SR Owner Full Name]
[$DETAIL].[SR Owner Supervisor] <-- not showing when a cell is double clicked…linked to [$SR_OWNER_SUP].[SR Owner Supervisor]
[$DETAIL].[Scenario]
[$DETAIL].[Extract Date]
[$DETAIL].[SR Number]
[$DETAIL].[Ultimate SR Num]
[$DETAIL].[Activity Number]
[$DETAIL].[SR Date Opened Utz]
[$DETAIL].[SR Date Assigned Utz]
[$DETAIL].[SR Date Closed Utz]
[$DETAIL].[Is Child SR]
[$DETAIL].[First Activity Created Utz]
[$DETAIL].[Abstract]
[$DETAIL].[Account Name]
[$DETAIL].[Activity Type]
[$DETAIL].[Source]
[$DETAIL].[SR Sub Status]
[$DETAIL].[Creator Workgroup]
[$DETAIL].[Owner Workgroup]
[$DETAIL].[Application]
[$DETAIL].[SR Sub Type]
[$DETAIL].[Open Calendar Month]
[$DETAIL].[Open Fiscal Month]
[$DETAIL].[TSLA Bus hrs]
[$DETAIL].[Account ID]
[$DETAIL].[Adjusted Date Opened]
[$DETAIL].[Adjusted Date Assigned]
[$DETAIL].[Acknowledgement Date]
[$DETAIL].[24Hr Deadline]
[$DETAIL].[24Hr Determination]
[$DETAIL].[48Hr Deadline]
[$DETAIL].[48Hr Deadline By Assigned Date]
[$DETAIL].[48Hr Determination]
[$DETAIL].[48Hr Determination by Assigned]
[$DETAIL].[5 Day Deadline]
[$DETAIL].[5 Day Determination]
[$DETAIL].[Interaction]
[$DETAIL].[Activity Interaction Type]
[$DETAIL].[SR Interaction Type]
[$DETAIL].[SR Only]
[$DETAIL].[Quarter Opened (Opened)]
[$DETAIL].[Quarter Opened (Assigned)]
[$DETAIL].[Parent Source]
[$DETAIL].[Phase]
[$DETAIL].[MCL Name]
[$DETAIL].[Activity Count]
[$DETAIL].[CORE_FOUR_REPORT_IN]
[$DETAIL].[CLIENT_INTERACTION_REPORT_IN]
[$DETAIL].[CHILD_SR_REPORT_IN]
[$DETAIL].[INCOMING_SR_REPORT_IN]
[$DETAIL].[OUTGOING_CASE_REPORT_IN]
[$DETAIL].
[LIST_TO_CASE_REPORT_IN]
[$DETAIL].[# of Interactions]

Thanks!

 

[bquackenbush]

Additional information: If I deactivate the relationships and double click a value in the pivot table, the new worksheet that opens displays the two fields that are included in the table relationships. Unfortunately, for me the entire point of using the relationships is to enable slicers to work across pivot tables built from different data tables, so disabling is not a good option.

Thanks