Pivot Table Issues

Fix Pivot Table Drill-Down Not Working in Excel for the Web

John WilsonJohn Wilson Nov 2, 2026 870 views

Question details

The user is unable to use the drill-down feature to view underlying data by double-clicking a PivotTable value while using the web-based version of the spreadsheet application.

How to Fix Pivot Table Drill-Down Not Working in Excel for the Web
Product
Excel for the Web
Device & OS
not provided
Scenario
Attempting to view the detailed underlying records of a summarized PivotTable value by double-clicking it in a browser environment.
Observed behavior
The drill-down action does not trigger the display of underlying records, unlike the standard behavior in the desktop version.
Before you start

Ensure that your original dataset contains the detailed underlying records and that the Pivot Table is correctly linked to this source data before attempting to troubleshoot.

Solution 1Recommended

Open the Workbook in the Desktop Application

Switch from the browser version to the full desktop application to access advanced Pivot Table features like data drill-down.

Excel for the web has certain feature limitations compared to the desktop version to optimize browser performance. Double-clicking a PivotTable value to extract and view underlying records (drill-down) is currently one of the features not fully supported online.

1
Locate the ribbon menu

While viewing your workbook in Excel for the web, look at the top ribbon navigation.

2
Select Open in Desktop App

Click the 'Viewing' or 'Editing' dropdown menu at the top of the screen, then select 'Open in Desktop App' from the list.

3
Confirm the browser prompt

If prompted by your web browser, click 'Open' or 'Allow' to launch the desktop application.

4
Perform the drill-down

Once the file opens in your desktop version, double-click the desired Pivot Table value to successfully generate a new sheet containing the underlying records.

Open the Workbook in the Desktop Application
Submit Feedback: You can use the 'Help' > 'Feedback' option in Excel for the web to submit a request or vote for adding PivotTable drill-down support to the browser version.
Free Microsoft Office alternative

Use WPS Office for Full Pivot Table Support on Desktop

Avoid browser limitations by switching to WPS Office. WPS Spreadsheets is a powerful, free alternative to Microsoft Excel that fully supports advanced Pivot Table features, including double-click data drill-down, ensuring you can analyze your underlying records without interruption.

Fully compatible with Microsoft Excel (.xlsx, .xls) file formatsSeamless Pivot Table creation, management, and drill-down supportLightweight desktop application that works completely offlineFamiliar user interface with zero learning curve for easy migration
microsoft office alternative - wps office

Frequently Asked Questions

What does 'drill-down' mean in a Pivot Table?

Drill-down is a data analysis feature that allows you to double-click on a summarized value within a Pivot Table to instantly create a new worksheet displaying all the underlying rows of data that make up that specific sum or count.

Will Excel for the web ever support Pivot Table drill-down?

Microsoft continually updates its web applications. While drill-down is currently limited online, users are encouraged to submit feedback through the Help menu to vote for this feature's implementation in future updates.

Why does double-clicking a cell in Excel for the web just enter edit mode?

Because the web version currently lacks the specific background trigger for Pivot Table drill-downs, double-clicking defaults to standard spreadsheet behavior, which simply enters text editing mode for that cell.

Can I view underlying Pivot Table records on a mobile device?

Similar to the web version, most mobile spreadsheet apps have limited support for advanced Pivot Table interactions. You will generally need to use a fully-featured desktop application like WPS Spreadsheets or desktop Excel to drill down into pivot data.