Fix Excel Pivot Table Double-Click Not Showing Details in Microsoft Teams
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.

- 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.
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.
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.
Open your preferred web browser and log into the Microsoft Teams web application.
Navigate to the specific channel or chat where the Excel workbook is shared.
Click the More Options (...) icon next to the file name and select 'Open in Excel for the web'.
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 File Directly in the Excel Desktop Application
Opening the file natively in the Microsoft Excel desktop app restores full functionality, including Pivot Table data exploration.
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. Download and Install WPS Office: Visit the official WPS Office website to download and install the free spreadsheet software.
- 2. Open Your Workbook: Launch WPS Spreadsheets and open your existing .xlsx file containing the Pivot Table.
- 3. Explore Data Instantly: Double-click any value in your Pivot Table to effortlessly generate a new sheet displaying all underlying records.

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.




