Office Apps Crashing

How to Fix Excel Crashing When Copying and Pasting a PivotChart

Steve K Oct 23, 2026 868 views

Question details

The user experiences unexpected crashes in Excel when trying to copy and paste a PivotChart.

How to Fix Excel Crashing When Copying and Pasting a PivotChart

Product: Microsoft Excel
Device & OS: Windows
Scenario: Copying and pasting a PivotChart in a new or existing workbook, particularly when the 'Add this data to the Data Model' feature is enabled.
Observed behavior: Excel abruptly closes or crashes completely during the copy-paste action. The issue persists across newly created simple tables and even when Excel is booted in Safe Mode.

Before you start

Ensure you have manually saved and backed up all important Excel workbooks before proceeding, as unexpected application crashes can result in data loss.

Solution 1Recommended

Revert Microsoft Office to a Previous Build

Since the crash persists in Safe Mode and across new workbooks, rolling back to an earlier stable version of Office can bypass bugs introduced in recent updates.

If a recent Office update broke the way Excel handles Data Model memory or clipboard interactions, returning to the previous version is the most reliable workaround until Microsoft releases a patch.

Open Command Prompt as Administrator

Click the Start menu, type 'cmd', right-click on 'Command Prompt', and select 'Run as administrator'.

Navigate to the ClickToRun Directory

Type the command 'cd %programfiles%\Common Files\Microsoft Shared\ClickToRun' and press Enter.

Execute the Reversion Command

Type 'officec2rclient.exe /update user updatetoversion=16.0.xxxxx.xxxxx' (replace the x's with the build number of the last known stable version) and press Enter to begin the downgrade process.

Revert Microsoft Office to a Previous Build

Disable Automatic Updates: After rolling back, remember to open Excel, go to File > Account > Update Options, and click 'Disable Updates' to prevent the buggy version from reinstalling automatically.

Solution 2

Test with a New Windows Administrator Account

Creating a fresh administrator account isolates the issue to see if corrupted user profile settings or local temporary files are causing the crash.

Solution 3

Perform a Clean Reinstallation of Microsoft 365

If Office or Windows shared components are severely corrupted, a clean reinstallation using the official recovery tool ensures all conflicting files are removed.

Free Microsoft Office alternative

Use WPS Office to Prevent Unexpected Spreadsheet Crashes

If Microsoft Excel continues to crash while handling PivotCharts and complex Data Models, consider switching to WPS Office. It provides a lightweight, highly stable spreadsheet environment that is fully compatible with Microsoft Office formats, allowing you to analyze data without interruptions.

1. Download WPS Office: Get the free WPS Office suite from the official website and install it on your PC.
2. Open Your Workbook: Launch WPS Spreadsheets and open the Excel (.xlsx) file containing your PivotChart and Data Model.
3. Manage PivotCharts Safely: Copy, paste, and analyze your data seamlessly without experiencing the crashes associated with recent Excel builds.

Highly stable performance when handling complex data and pivot tablesSeamlessly opens, edits, and saves standard Microsoft Excel .xlsx filesLightweight design consumes fewer system resources and prevents freezingFamiliar ribbon interface requires no steep learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel crash specifically when copying a PivotChart?

This is often caused by bugs in recent Office updates interacting improperly with the Data Model or system graphics drivers, causing memory leaks or rendering failures when transferring complex chart data to the clipboard.

Does disabling hardware graphics acceleration stop Excel from crashing?

While disabling hardware graphics acceleration used to resolve display-related crashes, Microsoft has removed this specific option in many newer versions of Microsoft 365. If the option is missing, you must rely on rolling back updates or repairing the installation.

Will opening Excel in Safe Mode fix the PivotChart copying crash?

Safe Mode temporarily disables add-ins and customizations. If the crash is caused by a core bug with the Data Model rather than a third-party add-in, Safe Mode will not resolve the issue, and the application will still crash.

Office App Problems