Fix Excel 2013 Crashes When Pasting Chart Formats
Question details
The user needs to prevent Excel 2013 from crashing when pasting chart formats.

- Product
- Microsoft Excel 2013
- Device & OS
- not provided
- Scenario
- Repeatedly copying a chart and using Paste Special to apply its formats, particularly on charts with many series and custom elements.
- Observed behavior
- Excel may crash during the operation, either across multiple workbooks or in one affected file.
Identify whether the crash happens in one workbook or in several, and note whether the affected charts contain many series or custom formatting. Close Excel before testing Safe Mode.
Test Chart Formatting in a New Workbook
Use a new workbook to determine whether the crash is tied to a particular file.
In Excel, select File > New > Blank workbook, enter sample data, and use Insert to create two charts.
Copy one chart, select the other, and use Home > Paste > Paste Special > Formats. Repeat the action to see whether Excel crashes.
If only the original workbook crashes, create a new workbook and copy its data and other needed content into it. Recreate affected charts if copying them also transfers the problem.

Check Excel Add-Ins and Background Services
Use Safe Mode and, if necessary, a clean boot to investigate conflicts that affect multiple workbooks.
Update or Upgrade Microsoft Office
Use this option if the crash persists after workbook and add-in testing.
Work With Excel Charts in WPS Spreadsheet
WPS Office is a free, lightweight Office alternative with a familiar interface. Open compatible Excel files in WPS Spreadsheet to continue working with data and charts as you move between office suites.

Frequently Asked Questions
How can I tell whether a workbook is causing the crash?
Create a blank workbook through File > New, add sample data and charts, and try Paste Special > Formats. If the new workbook works but the original crashes, the original file may be the cause.
How do I open Excel 2013 in Safe Mode?
Close Excel, press Windows+R, type excel /safe, and select OK. Safe Mode helps you test whether an add-in or startup customization is involved.
What should I do if Excel works in Safe Mode?
Restart Excel normally and go to File > Options > Add-ins. Use the Manage box and Go button to disable COM Add-ins and Excel Add-ins, then re-enable them one at a time while testing.
Can WPS Spreadsheet open my Excel chart workbook?
WPS Spreadsheet can open common Excel formats such as XLSX and XLS. Check complex charts and custom formatting after opening the file, as their appearance may differ between applications.




