sodcalculator

10 Tech How-To

Fix Excel Freezing When Copying or Pasting Large Data

Guide 10-35083 · Updated · Step by step

Excel freezing or becoming unresponsive during large copy-paste operations is a common frustration, especially when working with thousands of rows. This guide provides practical, step-by-step fixes to reduce or eliminate these freezes, improving your workflow and preventing data loss.

What You’ll Need

  • Access to the Excel file that is freezing (or a sample file to test).
  • Administrative rights to your computer (for some system-level fixes).
  • Patience – some fixes require restarting Excel or your PC.

Step-by-Step

  1. Save and Close Other Programs
    Excel often freezes because your system is low on memory (RAM). Close other heavy applications like browsers, video editors, or other Office programs. This frees up resources for Excel.
  2. Copy Only What You Need
    Instead of selecting entire columns (e.g., A:A), select only the range with data (e.g., A1:D5000). Entire columns include over a million cells, which can overwhelm Excel. Use Ctrl+Shift+End to jump to the last used cell, then select the actual data range.
  3. Use Paste Special – Values
    If you don’t need formatting, formulas, or data validation, use Paste Special:
    1. Copy your data (Ctrl+C).
    2. Right-click the destination cell.
    3. Choose Paste Special.
    4. Select Values and click OK.

    This reduces the amount of data Excel has to process, especially if the source has complex formatting.

  4. Disable Hardware Graphics Acceleration
    This feature can cause freezes, especially with large data. Go to File > Options > Advanced. Under the Display section, check Disable hardware graphics acceleration. Restart Excel.
  5. Turn Off Automatic Calculations
    If your workbook has many formulas, Excel recalculates after every paste. Set calculation to manual:
    1. Go to Formulas > Calculation Options.
    2. Select Manual.

    After pasting, press F9 to recalculate manually. Remember to switch back to Automatic when done.

  6. Clear Conditional Formatting Rules
    Conditional formatting can slow down copy-paste significantly. Select the entire data range, go to Home > Conditional Formatting > Clear Rules > Clear Rules from Entire Sheet. Do this on both source and destination if possible.
  7. Break the Paste into Chunks
    Instead of copying 100,000 rows at once, copy 10,000–20,000 rows at a time. This reduces the load on Excel’s memory and often prevents freezing.
  8. Use Excel’s Power Query (for repeated imports)
    If you regularly copy data from an external source, consider using Data > Get Data to import it. Power Query handles large data more efficiently and avoids the copy-paste freeze entirely.
  9. Repair Your Workbook
    If the issue persists, the workbook might be corrupted. Try:
    1. Open Excel, go to File > Open.
    2. Select the file, click the arrow next to Open, and choose Open and Repair.

    This can fix underlying issues causing the freeze.

  10. Update Excel and Windows
    Microsoft regularly releases patches for performance issues. Go to File > Account > Update Options > Update Now. Also check Windows Update.
  11. Disable Add-ins
    Third-party add-ins can cause conflicts. Go to File > Options > Add-ins. At the bottom, select COM Add-ins and click Go. Uncheck all add-ins and restart Excel. If the problem stops, re-enable them one by one to find the culprit.
  12. Copy Using a Macro (Advanced)
    If you are comfortable with VBA, you can use a macro that copies values only, which is faster. Press Alt+F11, insert a module, and paste this simple code: 
    Sub CopyValues()
    Selection.Copy
    Range("B1").PasteSpecial Paste:=xlPasteValues
    Application.CutCopyMode = False
End Sub

    Adjust the destination range as needed. Run it with F5.

Common Mistakes

  • Selecting entire rows/columns – This copies millions of empty cells, causing massive slowdowns.
  • Copying formatting unintentionally – Pasting with formatting (Ctrl+V) can be heavy; use Paste Special > Values.
  • Ignoring the status bar – If you see “Calculating” in the status bar, Excel is still processing; wait before doing anything else.
  • Not saving before a large paste – If Excel crashes, you lose work. Save your file before any large operation.
  • Using Ctrl+A in a sheet with stray data – This selects everything, including empty formatted cells far from your data. Use Ctrl+Shift+End instead.

Tips

  • Use Excel Tables – Convert your data range to a table (Ctrl+T). Tables handle data more efficiently and reduce calculation overhead.
  • Keep your data clean – Remove unused rows/columns by selecting them and pressing Ctrl+minus. This reduces the “used range” and speeds up operations.
  • Use 64-bit Excel – If you have a 64-bit system, ensure you have the 64-bit version of Office. It handles larger data sets better than 32-bit.
  • Disable DDE (Dynamic Data Exchange) – Go to File > Options > Advanced, scroll to General, and uncheck Ignore other applications that use Dynamic Data Exchange (DDE). This can prevent Excel from waiting for external updates.
  • Work in chunks – Even with all fixes, copying 500,000 rows in one go may still freeze. Plan to paste in stages.

Troubleshooting

If the problem persists after trying the steps above:

  • Check your RAM usage – Open Task Manager (Ctrl+Shift+Esc) and see if memory is above 90%. If so, close more programs or add more RAM.
  • Try a different file – Create a new workbook and copy the data there. If it works, the original file is likely corrupted.
  • Run Excel in Safe Mode – Press Win+R, type excel /safe, and press Enter. If it works, an add-in is the culprit. Disable them as described in Step 11.
  • Check for external links – Go to Data > Edit Links and break any links to other workbooks. External links can cause Excel to freeze during copy-paste.
  • Reset Excel settings – Go to File > Options > Advanced, and under General, click Reset to restore all settings to default (this does not delete your files).
  • Reinstall Office – As a last resort, uninstall and reinstall Microsoft Office. This fixes any corrupted installation files.

Frequently Asked Questions

Why does Excel freeze only when copying large amounts of data?

Excel has to load all the data into memory, check formatting, and often recalculate formulas. Large data sets can exceed available RAM, causing a freeze.

Can I increase Excel’s memory limit?

Excel uses your system’s RAM. You can’t increase its limit directly, but closing other programs and using 64-bit Excel can help. If you have 32-bit Office, consider upgrading.

Is there a faster way to copy data without freezing?

Yes, use Power Query to import data from external sources, or use a VBA macro that copies only values. Both are more efficient than standard copy-paste.

Will disabling hardware acceleration affect my Excel performance?

It might slightly reduce visual performance (like scrolling smoothness), but it often eliminates freezes and crashes. You can re-enable it later if needed.

How do I know if my Excel file is corrupted?

If Excel freezes even with small data, or if you get random errors, the file may be corrupted. Use the Open and Repair feature, and test with a new file.

Should I use Ctrl+Shift+End to select data?

Yes, this selects from the current cell to the last used cell, which is much better than selecting entire columns. It avoids copying empty cells.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →