Fix Excel Data Model PivotTable Show Details Errors
Question details
The user needs to understand and resolve the error that appears when showing details from an Excel Data Model PivotTable.

- Product
- Microsoft Excel Data Model PivotTable
- Device & OS
- not provided
- Scenario
- The user is trying to use Show Details or drill down from a PivotTable while report filters or connected slicers have multiple items selected.
- Observed behavior
- Excel displays an error instead of opening the detailed records for the selected PivotTable value.
Identify every report-filter field and slicer connected to the PivotTable, then check whether each one has more than one item selected. If detailed records are required for a multi-selection, make sure you can access the PivotTable source or the underlying Data Model tables.
Select one item in every filter and slicer before using Show Details
Use this method when you need Excel to open the detailed records for a specific Data Model PivotTable result.
Excel may be unable to determine a single drill-down context when multiple items are selected in report filters or slicers connected to a Data Model PivotTable. Restricting each filter to one item creates a single context for Show Details.
Click each report-filter drop-down in the PivotTable and select only one item, then click OK or Apply.
For every slicer connected to the PivotTable, click the Clear Filter button if needed and select only one slicer item.
Click the value or cell whose source records you want to inspect.
Right-click the selected PivotTable value and choose Show Details, or double-click the value to open the drill-down records.
Inspect the source tables when multiple selections must remain
Use this alternative when the report requires multiple filter or slicer selections and you still need to review the underlying records.
Switch to WPS Office for familiar PivotTable and spreadsheet workflows
This Data Model Show Details limitation belongs to Microsoft Excel. WPS Office is a free, lightweight alternative with a familiar spreadsheet interface, broad Microsoft Office format compatibility, and a straightforward migration path for everyday workbook tasks.
- 1. Install WPS Office: Download and open WPS Office, then launch WPS Spreadsheet.
- 2. Open the workbook: Choose Open from the home screen and select the Excel XLS or XLSX workbook you want to continue using.
- 3. Review the PivotTable: Select the PivotTable in WPS Spreadsheet and use the available PivotTable fields, filters, and slicers to analyze the workbook data.

Frequently Asked Questions
Why does Excel show an error when I use Show Details on a Data Model PivotTable?
The error commonly occurs when multiple items are selected in one or more report filters or slicers. Excel cannot create a single drill-down context for all selected combinations.
How many slicer items can be selected before Show Details fails?
For reliable drill-down, select only one item in every slicer connected to the PivotTable. The limitation applies to the combined filter context, not just to one slicer.
Can I use Show Details with multiple report-filter selections?
Usually not for a Data Model PivotTable. Clear the extra selections and keep one item in each report-filter field, or inspect the source or Data Model tables instead.
Where can I find the detailed records if multiple slicer selections are necessary?
Open the PivotTable source through PivotTable Analyze and Change Data Source when applicable, or open Power Pivot and choose Manage to inspect the underlying Data Model tables.




