Pivot Table Issues

Fix Excel Online PivotTable Not Showing Underlying Details

Natalie TaylorNatalie Taylor Nov 3, 2026 869 views

Question details

The user is unable to view the underlying source data details when double-clicking a value cell in an Excel Online PivotTable.

Fix Excel Online PivotTable Not Showing Underlying Details
Product
Excel Online
Device & OS
not provided
Scenario
Attempting to drill down into specific PivotTable aggregate values to inspect the underlying data records on the web.
Observed behavior
Double-clicking an item in the Excel Online PivotTable does not expand or generate a new sheet displaying the underlying data details.
Before you start

Ensure your Excel workbook is fully saved and synced to your OneDrive or SharePoint account before downloading a local copy to prevent any data loss.

Solution 1Recommended

Download and Open the File in a Desktop Spreadsheet Application

Because Excel for the web lacks the 'Show Details' drill-down feature, you must download the workbook and open it in a desktop application to view the underlying data.

Excel Online (Excel for the web) has limited support for advanced PivotTable interactions. The action of double-clicking a value to extract its underlying data rows is currently restricted to desktop spreadsheet applications.

1
Download a copy of the workbook

In Excel Online, click on the 'File' tab in the top-left corner, select 'Save As', and then click 'Download a Copy' to save the .xlsx file to your computer.

2
Open the file locally

Locate the downloaded file in your computer's Downloads folder and open it using Microsoft Excel Desktop or another compatible desktop spreadsheet program.

3
Show underlying details

Navigate to the PivotTable in the desktop application and double-click the specific value cell. A new worksheet will automatically be created, displaying all the underlying data rows that make up that value.

Download and Open the File in a Desktop Spreadsheet Application
Read-Only Alternative: If you cannot download the file, your only alternative in Excel Online is to manually go to the raw data sheet and apply filters to match the PivotTable criteria.
Free Microsoft Office alternative

Easily Analyze PivotTable Data with WPS Office Desktop

If you don't have the Microsoft Excel desktop application installed to view your PivotTable details, WPS Office provides a powerful, free, and lightweight alternative. It fully supports advanced spreadsheet features, including PivotTable drill-downs.

  1. 1. Install WPS Office: Download and install the free WPS Office suite on your Windows or Mac computer.
  2. 2. Open the downloaded Excel file: Launch WPS Spreadsheet and open the .xlsx file you downloaded from Excel Online.
  3. 3. View data details: Double-click any aggregated value in your PivotTable. WPS Spreadsheet will instantly create a new sheet displaying the underlying data.
100% free and lightweight desktop office suiteSeamless compatibility with Microsoft Excel (.xlsx) formatsFully supports PivotTable features, including double-click to show detailsFamiliar user interface requires no learning curve
QA img-9

Frequently Asked Questions

Why does double-clicking a PivotTable work on the desktop version but not online?

Excel for the web (Excel Online) is a streamlined version of the software. It currently lacks support for certain advanced data processing commands, including the 'Show Details' drill-down action that automatically generates a new sheet of source data.

Can I view the underlying PivotTable data without downloading the file?

Not automatically through the PivotTable. To view the data online, you must manually navigate to the source data worksheet and use the Filter tool on the column headers to isolate the specific records.

Will the underlying data sheet update automatically if the main data changes?

No. When you double-click a PivotTable cell in a desktop application to show details, the generated worksheet is a static snapshot of the data at that exact moment. You must delete the sheet and double-click the PivotTable cell again to see updated records.