Pivot Table Issues

Fix Excel Pivot Table Double-Click Not Showing Details in Microsoft Teams

Amos GikundaAmos Gikunda Nov 3, 2026 869 views

Question details

Users are unable to view underlying data records when double-clicking a value in an Excel Pivot Table opened directly within the Microsoft Teams interface.

How to Fix Excel Pivot Table Double-Click Not Showing Details in Microsoft Teams
Product
Microsoft Excel, Microsoft Teams
Device & OS
not provided
Scenario
Viewing and interacting with a shared Excel workbook containing a Pivot Table inside the Microsoft Teams desktop client.
Observed behavior
Double-clicking on a Pivot Table value fails to generate a new sheet with the detailed underlying records, a feature that normally functions correctly in the standard Excel application.
Before you start

Verify that your Microsoft Teams desktop client is updated to the latest version and ensure that the 'Enable show details' option is checked in your Pivot Table settings.

Solution 1Recommended

Open the Workbook in Excel for the Web or Teams Web App

Since the issue is often isolated to the Teams desktop client's integrated viewer, switching to the web version provides a quick workaround to view Pivot Table details.

The Excel viewer built into the Microsoft Teams desktop application sometimes restricts advanced interactive features. By opening the file in the web environment, you can bypass these rendering limitations.

1
Access the Teams Web App

Open your preferred web browser and log into the Microsoft Teams web application.

2
Locate the Excel File

Navigate to the specific channel or chat where the Excel workbook is shared.

3
Open in Excel for the Web

Click the More Options (...) icon next to the file name and select 'Open in Excel for the web'.

4
Test the Pivot Table

Locate the Pivot Table in the opened workbook and double-click the desired value to confirm that the underlying details are successfully generated in a new sheet.

Open the Workbook in Excel for the Web or Teams Web App
Client-Specific Issue: If this feature works perfectly in the web version but not the desktop client, the issue is specific to the Teams desktop app. You may need to clear your Teams cache or wait for a software patch from Microsoft.
Free Microsoft Office alternative

Use WPS Office for Reliable Pivot Table Management

If you frequently encounter integration bugs and limitations with Microsoft Excel inside Teams, consider switching to WPS Office. It provides a lightweight, fully compatible environment for managing complex spreadsheets and Pivot Tables without the hassle of integrated viewer glitches.

  1. 1. Download and Install WPS Office: Visit the official WPS Office website to download and install the free spreadsheet software.
  2. 2. Open Your Workbook: Launch WPS Spreadsheets and open your existing .xlsx file containing the Pivot Table.
  3. 3. Explore Data Instantly: Double-click any value in your Pivot Table to effortlessly generate a new sheet displaying all underlying records.
Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Seamlessly double-click Pivot Tables to instantly view detailed underlying data recordsLightweight application that opens large files quickly without freezingFree to use with a familiar, user-friendly interface that requires no learning curve
microsoft office alternative - wps office

Frequently Asked Questions

Why does double-clicking a Pivot Table work in Excel but not in Microsoft Teams?

The file viewer integrated into the Microsoft Teams desktop client has limited processing capabilities compared to the standalone desktop or web versions of Excel. Certain interactive features, such as generating drill-down detail sheets from Pivot Tables, are occasionally restricted or experience rendering bugs within the Teams interface.

How do I clear the Microsoft Teams cache to fix application glitches?

To clear the Teams cache on Windows, completely close the application. Press Win + R to open the Run dialog, type '%appdata%\Microsoft\Teams', and press Enter. Delete all files and folders within this directory. Restart Teams and check if the Pivot Table functionality is restored.

Is there a setting in Excel to enable or disable 'Show Details' for Pivot Tables?

Yes. In Excel, right-click any cell inside the Pivot Table, select 'PivotTable Options', and navigate to the 'Data' tab. Ensure the checkbox for 'Enable show details' is checked. If this is disabled, double-clicking will not work on any platform, including Teams or the web.