How to Fix PivotTable Show Details Adding Extra Rows in Excel
Question details
Users need a way to stop Excel from adding extra metadata rows when extracting underlying records from a PivotTable.

- Product
- Microsoft Excel
- Device & OS
- Windows 11
- Scenario
- Double-clicking a PivotTable value to show details (extract records) after a recent Microsoft 365 or Windows 11 update.
- Observed behavior
- Excel generates the underlying data sheet but includes additional, unwanted rows containing metadata alongside the actual records.
Ensure your Microsoft 365 subscription is fully up to date, as Microsoft frequently releases patches that may alter PivotTable extraction behaviors. Identify exactly which rows are metadata so you can safely filter or remove them without losing actual data.
Manually Remove Extra Rows and Submit Feedback
Since there is no built-in setting to disable this new behavior, the most direct approach is to manually clean the extracted data and submit feedback to Microsoft.
This behavior was introduced in recent Microsoft 365 updates. Currently, Microsoft does not provide a standard toggle to turn off these metadata rows.
Double-click the desired value in your PivotTable to generate the 'Show Details' sheet with the underlying records.
Select the newly generated worksheet, highlight the row numbers of the unwanted metadata added at the top or bottom, right-click, and select 'Delete'.
To help prioritize a permanent fix, go to the 'Help' tab in Excel, click 'Feedback', and submit a feature request asking for an option to disable extra metadata rows in PivotTable details.

Automate Data Extraction Using Power Automate
For cloud-based workbooks, you can use Power Automate to extract only the necessary records without the default metadata.
Try WPS Office for a Cleaner Spreadsheet Experience
If recent Microsoft Excel updates are disrupting your PivotTable workflows with unwanted metadata, consider switching to WPS Office. It offers a lightweight, familiar interface and handles PivotTables and data extraction without forcing extra rows into your sheets.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
- 2. Open Your Workbook: Launch WPS Spreadsheet and open your existing .xlsx files directly.
- 3. Extract Data Cleanly: Double-click your PivotTable values to extract the underlying data smoothly, exactly as you expect.

Frequently Asked Questions
Why does Excel add extra rows when I double-click a PivotTable value?
Recent updates to Microsoft 365 and Windows 11 modified the 'Show Details' feature to include metadata alongside the underlying records. This is currently an intended update by Microsoft rather than a bug.
Is there an Excel setting to turn off these metadata rows?
No, there is currently no standard setting or toggle in Excel Options to disable the extra metadata rows when extracting PivotTable details. Microsoft relies on user feedback to prioritize future settings.
Does this issue happen in older versions of Excel?
Typically, no. This behavior is primarily observed in newer builds of Microsoft 365 and Excel for Windows 11. Older standalone versions like Excel 2016 or 2019 usually extract only the raw data.
How can I speed up the removal of these extra rows?
You can record a simple Excel Macro (VBA) that deletes specific row ranges after you trigger the 'Show Details' action, and assign it to a keyboard shortcut for quick cleanup.




