Excel crashes copying large datasets: the real fix

Quick answer

Use Paste Special → Values instead of Ctrl+V. Or turn off hardware graphics acceleration in Excel options (File → Options → Advanced → Display → uncheck 'Disable hardware graphics acceleration').

What's actually happening here

Excel's clipboard system wasn't designed for 50,000+ rows of complex data — especially when formulas, conditional formatting, or merged cells are involved. When you hit Ctrl+C on a large range, Excel tries to hold all that data, formatting, and formula references in memory. On top of that, the built-in paste preview (introduced in Excel 2016) triggers a background recalculation, which can collide with your active workbook's calculation thread — causing a hard freeze or crash.

This happens most often on Windows 10 or 11 systems with 8GB or less RAM, or when the workbook contains volatile functions like INDIRECT, OFFSET, RAND, or NOW. I've seen it on Excel 2019 and 365 specifically when copying from a PivotTable cache or a sheet with 100+ named ranges.

The fix steps (in order of effectiveness)

1. Use Paste Special → Values (Alt+E, S, V then Enter). This strips all formatting and formulas. The clipboard only holds raw text and numbers, which Excel handles much better. If you need formatting, paste values first, then copy formatting separately from a small cell.
2. Disable hardware graphics acceleration. Go to File → Options → Advanced. Scroll to the Display section. Check 'Disable hardware graphics acceleration'. Restart Excel. The reason this works: Excel offloads some rendering to the GPU, which can cause deadlocks when the GPU driver chokes on a huge clipboard buffer. Turning it off forces rendering through the CPU — slower, but stable.
3. Copy in chunks. Select 10,000 rows at a time, paste, then repeat. Annoying, but it works when step 1 and 2 fail. The real issue is that Excel's internal clipboard format (CF_BITMAP for formatting, CF_TEXT for data) gets corrupted when the buffer exceeds ~500MB. Chunking keeps each copy under that threshold.
4. Turn off Paste Preview. File → Options → General → under 'Cut, copy, and paste', uncheck 'Show Paste Options button when content is pasted'. This disables the live preview that triggers recalculation. Works well for Excel 365 users.

When those don't work

If the crash persists, try these alternative approaches:

• Use a table (Ctrl+T on your data range). Tables handle copy-paste internally more efficiently because Excel treats them as a single structured object. After converting, copy the table, not the range.
• Copy via formula. In the destination sheet, type =Sheet1!A1 and drag-fill. This bypasses the clipboard entirely. Downside: you get live links, not static values. To break links, copy the formula results and paste as values.
• Save as .xlsb (Binary workbook format). This reduces file size and memory use dramatically. A 50MB .xlsx can shrink to 15MB in .xlsb. Smaller memory footprint = less crash risk during clipboard ops.
• Update your GPU drivers. Specifically for Intel Iris Xe or NVIDIA Optimus laptops. Outdated drivers have known bugs with Excel's hardware acceleration. Run DDU (Display Driver Uninstaller) in safe mode, then install the latest driver clean.

Preventing it next time

The real prevention is avoiding copying from full-column references. Instead of selecting entire columns (A:A), select only the actual data range (A1:A50000). Also, disable 'Show paste options button' permanently — it's a feature that causes more crashes than it solves. If you regularly work with datasets over 100K rows, consider Power Query for transformations instead of copy-pasting. Power Query loads data into the data model, not the grid, so you never hit clipboard limits.

One more thing: if your workbook uses iterative calculation (File → Options → Formulas → Enable iterative calculation), turn it off before copying large ranges. Iterative calculation keeps the calculation engine in a loop state, which conflicts with clipboard operations and causes hard locks.