Pivot Table Issues

Fix Excel Crashes When Drilling Down in a PivotTable

Anum MushtaqAnum Mushtaq Nov 13, 2026 869 views

Question details

Excel crashes when a user drills into a PivotTable result and then deletes the resulting detail worksheet or uses Undo.

Fix Excel Crashes When Drilling Down in a PivotTable
Product
Microsoft Excel
Device & OS
not provided
Scenario
A user double-clicks a PivotTable value to view its underlying records in a new worksheet.
Observed behavior
Excel may crash during drill-down or after the detail worksheet is deleted or Undo is used. The issue can be intermittent and affect multiple workbooks or users.
Before you start

Identify a PivotTable value that produces a detail worksheet when double-clicked, and note whether the crash follows drill-down, deletion, or Undo. Perform the tests on a copy of the workbook because inspection and repeated crash testing can change or discard content.

Solution 1Recommended

Rebuild and Test the PivotTable in a New Workbook

Use a fresh workbook to determine whether the issue is specific to the original file.

1
Create a new workbook

In Excel, select File > New > Blank workbook.

2
Add source data

Copy the relevant source data into the new workbook rather than copying the original PivotTable. If the source is a SQL view or stored procedure, use a suitable sample of its results for this initial test.

3
Build a PivotTable

Select the source data, choose Insert > PivotTable, and recreate a simple version of the affected PivotTable.

4
Repeat the drill-down

Double-click a value in the new PivotTable. Test deleting the resulting detail worksheet and using Undo, as appropriate, to see whether Excel still crashes.

Rebuild and Test the PivotTable in a New Workbook
Interpret the result: If the new workbook works, the original workbook may contain problematic content or be corrupted. A test using copied data does not rule out an issue with an external SQL connection.
Free Microsoft Office alternative

Work with PivotTables in WPS Spreadsheet

WPS Office is a free, lightweight alternative with a familiar interface and support for Microsoft Office formats, making it easy to move everyday spreadsheet work. It does not repair an Excel-specific crash.

Create and review PivotTables in WPS SpreadsheetOpen and save Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for everyday analysisMove compatible Office files without starting from scratch
microsoft office alternative - wps office

Frequently Asked Questions

What happens when I double-click a PivotTable value?

Excel normally creates a new worksheet showing the underlying records for that value. This is often called drill-down or Show Details.

Does a successful test in a new workbook prove the original file is corrupted?

No. It suggests the original workbook or its contents may be involved, but it does not prove corruption. If the test uses copied data, it also does not fully test the original external connection.

Where is Document Inspector in Excel?

Open a copy of the workbook and go to File > Info > Check for Issues > Inspect Document. Review each finding before removing content.

What should I do if several coworkers experience the same crash?

Collect the Excel version from File > Account, the affected workbook and connection details, and the results of a new-workbook test. Share them with your Microsoft 365 administrator.

Can WPS Office fix the Excel crash?

WPS Office does not fix a crash in Microsoft Excel. WPS Spreadsheet is an alternative for compatible spreadsheet work, but you should verify any SQL connections and advanced workbook features before relying on them.