Excel crashes on copy-paste between workbooks with conditional formatting

When this happens

You're working in Excel 2019 or 365 on Windows 10 or 11. You select a range of cells in Workbook A that has conditional formatting rules applied—maybe color scales, data bars, or icon sets. You hit Ctrl+C, switch to Workbook B, and press Ctrl+V. Excel freezes for a few seconds, then crashes to desktop. No save, no warning.

This isn't a random bug. It's a known issue that hits hardest when the conditional formatting rules in the source workbook reference other sheets or external workbooks. The paste operation tries to merge those rules into the destination workbook's conditional formatting system, and sometimes those references break or conflict, taking down the whole application.

What's actually happening

Excel's conditional formatting engine stores each rule as a FormatCondition object tied to a range. When you copy a range with these rules, Excel serializes everything—the rule formulas, the formatting definitions, and any external references. Pasting that into another workbook forces Excel to parse and rebuild those objects in the new context. If a rule references a named range or a sheet that doesn't exist in the destination, Excel's internal resolver chokes.

The crash is worst when you have rules like "Format cells if value is greater than =Sheet2!A1"—that sheet reference is relative to the source workbook, and the destination has no idea what to do with it. Instead of gracefully ignoring it, Excel tries to evaluate it and segfaults.

The fix: paste values only (the right way)

The real fix is to stop Excel from trying to merge the conditional formatting in the first place. You'll copy the data without formatting, then reapply the rules only if you need them.

1. Save both workbooks first. Excel can crash during this process even with the fix if the destination is unsaved. Save both, then close and reopen the destination workbook to clear any stale cache.
2. In the source workbook, copy the range normally. Ctrl+C works fine—you're just grabbing the data.
3. Switch to the destination workbook and use Paste Special. Don't hit Ctrl+V blindly. Instead, right-click the destination cell, choose Paste Special > Values. Or use the keyboard shortcut: Ctrl+Alt+V, then V, then Enter.
4. If you must preserve the conditional formatting, you have two options:
   • Copy the entire worksheet instead of just the range. Right-click the sheet tab in the source, choose Move or Copy, check Create a copy, and select the destination workbook. This copies all rules intact because Excel handles whole-sheet moves differently—it remaps references relative to the new workbook.
   • Or, recreate the conditional formatting manually in the destination. Painful, but stable. Use the Conditional Formatting > Manage Rules dialog and redefine them with local references only.
5. After pasting values only, you can reapply conditional formatting to the pasted data if you want—just define new rules that don't reference the source workbook.

Why step 3 works

Paste Special > Values strips everything except the raw cell data—no conditional formatting, no formulas, no merged cells, no borders. Excel's paste engine doesn't even attempt to create FormatCondition objects, so there's nothing to crash on. The data lands clean. You lose the formatting, but you don't lose the crash.

If it still crashes

Try these in order:

• Disable hardware graphics acceleration. Go to File > Options > Advanced > scroll to Display > check Disable hardware graphics acceleration. Restart Excel. The GPU rendering can sometimes interfere with conditional formatting rendering during paste operations.
• Check for add-ins. Go to File > Options > Add-ins. Disable COM add-ins like VBA tools, analysis packs, or third-party Excel extensions. Restart. Conditional formatting crashes are often amplified by buggy add-ins that hook into the paste event.
• Repair Office. Run Control Panel > Programs > Microsoft Office > Change > Quick Repair. If that doesn't fix it, do an Online Repair. This replaces corrupted DLLs that handle the conditional formatting engine.
• Update Excel. Microsoft has patched some of these crashes in later builds of Office 365. Go to File > Account > Update Options > Update Now. If you're on a perpetual version like Office 2019, you're stuck with the bug—use the paste-values workaround.

One more thing: if you're copying from a workbook with hundreds of conditional formatting rules (yes, people do this), Excel's rule manager is already close to its limit. Each worksheet can technically hold thousands of rules, but the paste operation tries to process them all simultaneously. In that case, split the copy into smaller ranges—10 rows at a time, not the whole sheet.