Fix Excel Crashes When Drilling Down in a PivotTable
Question details
Excel crashes when a user drills into a PivotTable result and then deletes the resulting detail worksheet or uses Undo.

- 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.
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.
Rebuild and Test the PivotTable in a New Workbook
Use a fresh workbook to determine whether the issue is specific to the original file.
In Excel, select File > New > Blank workbook.
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.
Select the source data, choose Insert > PivotTable, and recreate a simple version of the affected PivotTable.
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.

Inspect a Copy of the Workbook for Hidden Content
Check for hidden workbook content that may be contributing to a file-specific issue.
Escalate Crashes Affecting Multiple Excel Users
Ask your Microsoft 365 administrator to investigate when the problem occurs across users or workbooks.
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.

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.




