Fix Pivot Table Drill-Down Not Working in Excel for the Web
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.

- 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.
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.
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.
While viewing your workbook in Excel for the web, look at the top ribbon navigation.
Click the 'Viewing' or 'Editing' dropdown menu at the top of the screen, then select 'Open in Desktop App' from the list.
If prompted by your web browser, click 'Open' or 'Allow' to launch the desktop application.
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.

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.

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.




