Excel Not Responding When Copying and Pasting: Fixes

If Excel says “Not Responding” when you copy or paste, first wait briefly in case it is processing a large range, then press Esc and try copying a few cells in a new blank workbook. If Excel still freezes, save what you can, restart Excel, and troubleshoot add-ins, clipboard issues, and the affected workbook before forcing the app to close.

First, tell a temporary pause from a freeze

Excel may stop refreshing its window while it handles a large paste, recalculates formulas, or updates charts and other objects. “Not Responding” does not necessarily mean the workbook is damaged. Give the operation time, especially if you copied many rows, a whole column, or cells containing formulas and formatting. Check whether Excel is using CPU in Windows Task Manager, but do not treat activity as proof that the operation will finish immediately.

Before taking a more disruptive step, try these checks:

Wait a minute or two for a large operation, and avoid repeatedly clicking the window or pressing paste.
Press Esc once to attempt to cancel the current operation. If Excel responds, save the workbook.
Try a small copy-and-paste in a new blank workbook. This helps separate an Excel-wide issue from a problem limited to one file.
If the workbook is still responsive, save a separate copy before testing changes that might affect formulas, links, or formatting.

If Excel has genuinely stopped responding, ending the task can lose unsaved changes. Use Task Manager’s End task only as a last resort. When you reopen Excel, check for a Document Recovery pane or a recovered version of the file; recovery may not include the latest edits.

Check whether the problem is Excel, the clipboard, or one workbook

Copying involves more than the selected cells: Excel places cell content and formatting on the clipboard, while Windows and other applications may also use that clipboard. A failure can therefore appear as an Excel freeze even when the workbook itself is not the cause. A quick comparison can narrow it down.

Test within Excel: Open a new blank workbook and copy a few ordinary cells to another area. If this works, the original workbook or the size and content of the selection may be involved.
Test another application: Copy a short line of text from Notepad into Excel. If that works but copying cells does not, the issue may be related to Excel’s cell clipboard or workbook content.
Test another workbook: If small copies work in other files but not one particular file, focus on that workbook’s formulas, objects, links, or file condition.
Check the destination: Try a different sheet or a blank workbook. A protected sheet, merged cells, or a destination range that does not match the copied area can change how a paste behaves, even if it does not usually cause a full application freeze.

These tests are clues, not definitive diagnoses. For example, a large selection can work in a blank file but stall in a workbook with thousands of formulas because the paste triggers recalculation.

Try the least disruptive clipboard fixes

Start by canceling any active copy operation with Esc, then make a fresh selection and copy it again. If Excel is responsive, close other applications that may be using the clipboard and retry a small range. Restarting Excel can also clear a stuck session, but save first if possible.

Windows clipboard history is separate from Excel’s own Clipboard pane. If Windows clipboard history appears to be involved, press Windows key+V and use the available clear option, or open Settings > System > Clipboard and select Clear clipboard data. This removes clipboard history, so do not use it if you need an item stored there. In Excel, the Clipboard pane is available from Home > Clipboard using the small dialog box launcher in the Clipboard group; its Clear All command clears items shown in that pane. Clearing either clipboard is a troubleshooting step, not a guaranteed fix.

For a simple transfer, test Paste Values or Paste Special only after Excel is responsive. These commands can avoid bringing all formatting and formulas into the destination, but they cannot make an unresponsive application accept input. If the source selection is very large, copying only the actual populated cells is usually a better test than copying entire rows or columns.

Look for add-ins that interfere with copying

Some Excel add-ins and other Office extensions interact with cell selection, clipboard contents, or workbook files. To check whether an add-in is contributing, start Excel in Safe Mode on Windows: close Excel, press Windows key+R, type excel /safe, and press Enter. Then test a small copy and paste. Safe Mode starts Excel with certain customizations and add-ins disabled; it does not repair the workbook.

If copying works in Safe Mode, disable add-ins in regular Excel and test them one at a time:

Open File > Options > Add-ins.
At the bottom, note the add-in type beside Manage, such as COM Add-ins, and select Go.
Clear the check boxes to disable the listed add-ins, then restart Excel normally.
Re-enable add-ins individually, testing copy and paste after each change. This can identify the one that triggers the problem.

Excel Add-ins and COM Add-ins are different categories, so check the relevant category rather than assuming one list contains everything. Do not permanently remove an add-in that your organization requires; ask your IT administrator if the workbook depends on a managed extension.

Check for workbook-specific causes

A paste can trigger substantial work when the destination workbook contains formulas, conditional formatting, data validation, external links, charts, or other objects. Copying cells can also carry formatting and formulas, not just visible values. A large selection may therefore take much longer to paste than its apparent amount of data suggests.

If one file is affected, make a backup copy and test the following in that copy:

Copy a small range of plain values instead of a whole sheet or entire columns.
Try a different destination sheet. Check whether the destination has merged cells or sheet protection that affects editing.
Look for formulas that refer to large ranges or external workbooks. A paste may cause recalculation or link updates.
Check Formulas > Calculation Options. If calculation is set to Automatic, a paste that changes many precedent cells can start a lengthy recalculation. Switching to Manual can reduce repeated recalculation during a controlled test, but it also leaves formulas potentially out of date until you calculate them. Restore the setting you need afterward.
If the file is stored on a network, cloud location, or shared drive, save a local copy and test it. This can help distinguish a workbook operation from a sync or connection delay.

Do not assume a freeze means the workbook is corrupt. If the issue persists only in one file, try Excel’s File > Open > Browse route, select the workbook, use the arrow beside Open, and choose Open and Repair if that option is available. Keep the original file unchanged and review any repaired copy carefully, since repair can affect workbook content.

Update or repair Microsoft 365 if all workbooks are affected

If copy and paste freezes Excel in multiple workbooks, restart Windows and install available Office updates. In Excel, use File > Account > Update Options > Update Now if those controls are available. In managed work environments, update options may be controlled by an administrator.

If the problem continues, use Windows to repair Microsoft 365. In Windows 11, open Settings > Apps > Installed apps, find Microsoft 365, select the three-dot menu, and choose Modify. In Windows 10, the route is Settings > Apps > Apps & features, then select Microsoft 365 and Modify. Quick Repair is the less extensive first option; if it does not help, Online Repair may be offered. Repair can require an internet connection or sign-in, and the exact labels can vary by Office installation. Save work and close Office apps before starting.

On Excel for Mac, Windows paths such as Safe Mode with excel /safe, Task Manager, and Windows Settings do not apply. Use Command+C and Command+V rather than Ctrl+C and Ctrl+V, and check for Office updates through Help > Check for Updates if that option appears in your installation. Excel for the web runs in a browser; test the desktop app or another browser if the problem seems limited to web-based clipboard access.

Reduce the chance of another copy-and-paste hang

For routine work, copy only the cells you need and avoid selecting entire columns or sheets when a smaller range will do. When moving data between workbooks, consider whether you need formulas and formatting or only the displayed values; unnecessary formatting and formulas can add work and make files larger. If you are repeatedly transferring a large dataset, importing or transforming it with Power Query may be more reliable than manually copying a very large range.

Keep a backup before making structural changes to a workbook, particularly if it contains macros, links, or complicated formulas. Save periodically and allow recalculation to finish before starting another large paste. If the issue recurs, note whether it affects one workbook, one add-in, one destination, or all files; that information makes the next troubleshooting step much more targeted.

Frequently Asked Questions

Why does Excel freeze when I copy a large range?
A large range can include formulas, formatting, validation rules, and other content in addition to the visible values. Pasting it may also trigger recalculation or updates to charts and links. Test with a smaller populated range and, if appropriate, paste values only.

Can I close Excel when it says Not Responding?
You can end the task from Task Manager, but unsaved changes may be lost. Wait first if Excel may be processing a large operation, try Esc, and save if the window becomes responsive. After restarting, check for Document Recovery, but do not assume it has every recent change.

Why does copy and paste work in Safe Mode?
Safe Mode disables some customizations and add-ins, so success there points toward an add-in or customization as a possible cause. Disable add-ins in regular Excel and test them one at a time to find the source.

Will clearing the clipboard delete my workbook data?
No. Clearing Windows clipboard history or Excel’s Clipboard pane removes copied items held on the clipboard; it does not delete the workbook’s cells. However, it can remove copied material you intended to paste later.

Why does Excel freeze only in one file?
That file may contain a large calculation workload, external links, extensive formatting, or objects that make pasting expensive. Test a backup copy with a small range and a different destination before attempting repair.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.