Excel crashes copying/pasting charts with linked data – fix

Why Excel crashes

You make a chart in Excel, maybe it pulls data from another workbook or from a database query. You copy that chart – Ctrl+C – and the moment you paste it, Excel freezes solid. Or you get the spinning beach ball. Or Excel just vanishes.

This isn't random. The crash happens because Excel's OLE (Object Linking and Embedding) engine chokes when it tries to resolve the external data links during the paste operation. I've seen it on Excel 2016, 2019, and Office 365 – doesn't matter the version. The fix depends on how deep you want to go.

Try these in order. You can stop at any step that fixes it.

Step 1: The 30-second checkbox fix – Disable hardware graphics acceleration

Excel's graphics engine can trip over chart rendering when copying. The quickest test is to turn off hardware acceleration.

1. Open Excel. Don't open the problem file yet.
2. Click File > Options.
3. Click Advanced – it's near the bottom of the left menu.
4. Scroll down to the Display section. About halfway down the list.
5. Check the box that says Disable hardware graphics acceleration.
6. Click OK.

After you click OK, Excel will restart if it prompts you. If it doesn't, close Excel manually and reopen it.

What you should see: Excel looks a little flatter – no fancy animations or smooth scrolling. That's fine. Now open your workbook and try copying and pasting that chart again. If it works, you're done. Leave that box checked. If it still crashes, move to Step 2.

Step 2: The 5-minute fix – Paste without the link

If hardware acceleration wasn't the problem, the issue is almost certainly the live data link. Excel is trying to refresh the link during the paste, and that's what kills it. Break the link before you copy.

1. Open your workbook that has the chart.
2. Right-click the chart. Choose Select Data from the menu.
3. In the Select Data Source dialog, look at the Chart data range box at the top. If it shows a reference to another workbook (like C:\Users\...\data.xlsx), you've got a linked chart.
4. Click Edit under Legend Entries (Series).
5. In the Series values field, replace the external link with the same cell range from the current workbook. Example: Change ='[ExternalWorkbook.xlsx]Sheet1'!$A$1:$A$10 to =Sheet1!$A$1:$A$10.
6. Click OK and then OK again.
7. Now copy the chart (Ctrl+C) and paste it where you need it.

What you should see: The chart should paste instantly. No freeze, no crash. The downside is you lose the live link – the data won't update automatically from the external source anymore. If you need the link to stay live, you'll need the registry fix in Step 3.

But honestly, if you can live without the link, stop here. It's the most reliable fix.

Step 3: The 15+ minute fix – Registry edit to disable OLE link checking on paste

This is for people who must keep the external data link alive and still copy/paste charts. We're going to tell Excel to stop checking OLE links during the paste operation. This requires editing the Windows Registry, so be careful.

Back up your registry first: Open Regedit, click File > Export, and save a backup somewhere safe. If something goes wrong, double-click that backup file to restore it.

1. Close Excel completely.
2. Press Windows Key + R, type regedit, and press Enter.
3. Go to one of these paths, depending on your Excel version:
   • Excel 2016, 2019, Office 365 (64-bit): HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options
   • Excel 2013: HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Excel\Options
   • Excel 2010: HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options
4. Right-click in the right pane. Choose New > DWORD (32-bit) Value.
5. Name it DisablePasteChartLinkingCheck.
6. Double-click that new value, set the Value data to 1, and click OK.
7. Close Regedit.

What you should see: Open Excel and your workbook. Copy that linked chart and paste it. It should work now – the paste happens without Excel trying to resolve the link. The link stays intact, so the chart data updates from the external source when you refresh.

If it doesn't work, double-check you used the right registry path and that the DWORD name is exactly DisablePasteChartLinkingCheck – case-sensitive, no spaces.

What if none of these work?

In the rare case the registry edit doesn't help, you've got a corrupted chart or workbook. Try this:

• Open the workbook in Safe Mode. Hold Ctrl while you double-click the Excel icon. Click Yes when asked to open in Safe Mode. Try copying the chart there. If it works, a corrupt add-in is the culprit. Disable all add-ins via File > Options > Add-ins.
• Copy the chart's underlying data to a new workbook, rebuild the chart from scratch, and paste that new chart. Tedious but works every time.

I've seen this crash pattern hundreds of times over the years. Step 2 (pasting without the link) is the real fix for most people. The registry hack is for power users who can't lose the external link. Start with Step 1 – it's free and takes 30 seconds. You'll likely land on Step 2 and be done in five minutes.