How to Show Details for Excel PivotTable Values
Question details
The user wants to know whether Excel removed Show Details from the PivotTable right-click menu and how to extract the underlying records.

- Product
- Microsoft Excel PivotTables
- Device & OS
- not provided
- Scenario
- The user wants to inspect the records behind a summarized PivotTable value.
- Observed behavior
- Show Details may be absent from the right-click menu, but double-clicking a value can still open its underlying records.
Open the workbook containing the PivotTable and identify a numeric cell in its Values area. If you cannot extract details, check whether the PivotTable's Show Details setting is enabled.
Double-click a PivotTable value to extract its records
Use this method when Show Details is missing from the right-click menu.
Click a numeric cell in the PivotTable Values area, such as a sum or count.
Double-click the value. If a Show Details dialog appears, follow its prompts.
Open the worksheet Excel creates to inspect the underlying records for the selected value.

Enable Show Details in PivotTable options
Check this setting if double-clicking a value does not extract records.
Explore PivotTable data with WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel workbooks in WPS Spreadsheets for an easier transition, though it does not restore commands in Microsoft Excel.

Frequently Asked Questions
Was Show Details removed from Excel PivotTables?
The command may be missing from the right-click menu in some Excel versions. You can still try double-clicking a numeric cell in the PivotTable Values area to extract its details.
Where do the extracted records appear?
When drill-down succeeds, Excel creates a new worksheet containing the records behind the selected PivotTable value.
Why doesn't double-clicking a value show the records?
Right-click the PivotTable, open PivotTable Options, and check Enable show details on the Data tab. The data source may also restrict the details available.
Can I ask Microsoft to restore the right-click command?
Yes. In Excel, use File > Feedback or Help > Feedback, depending on your version, to request the return of Show Details to the context menu.




