Excel Not Responding After Copy and Paste? Fix It

If Excel says “Not Responding” after you copy and paste, first give it a little time: a large paste or recalculation can temporarily occupy the program. If it remains frozen, try Esc, check whether Excel is still working, and then troubleshoot the pasted range, workbook, add-ins, or Office installation before forcing Excel to close.

What “Not Responding” means

In Windows, “Not Responding” usually means Excel is not currently responding to Windows’ requests for input. It does not, by itself, prove that Excel has crashed or that your workbook is damaged. Excel may be busy processing a large block of cells, applying formats, updating formulas, refreshing links, or communicating with another program through the clipboard.

Copying and pasting can involve more than the visible cell values. A normal paste may also bring over formulas, number formats, borders, conditional formatting, comments or notes, and other cell properties. A large range with complex formatting can take longer than a similarly sized range of plain values. If formulas recalculate across many sheets, the paste can trigger additional work after the cells appear to have been inserted.

There is no fixed waiting time that is right for every workbook. A small, simple paste should usually finish quickly, while a large or formula-heavy workbook may need longer. If the Excel window is still changing, the computer is busy, or a progress indicator appears, avoid repeatedly clicking the window or starting another copy-and-paste operation.

What to do before closing Excel

Protect your work first. If Excel has only been unresponsive for a short time, wait and avoid clicking repeatedly; repeated input can queue up and make it harder to tell whether the program has recovered. If a calculation or other progress indicator is visible, let it complete if practical.

Press Esc once. This may cancel a current selection, copy mode, or operation, but it cannot always interrupt a task Excel is already processing.
Look for signs of activity, such as changing CPU use in Task Manager, a progress message, or the window recovering briefly. Activity does not guarantee Excel will finish, but it can help distinguish a busy application from an idle one.
If Excel responds again, save the workbook with Ctrl+S before trying another paste. If the workbook is not saved yet, use Save As to make a separate copy when possible.
Only use Task Manager to end Excel as a last resort—for example, if it has remained unresponsive and shows no sign of progress. Ending the task can discard unsaved changes.

On Windows, open Task Manager with Ctrl+Shift+Esc. Select Microsoft Excel and choose End task only if you have decided that waiting is no longer useful. On a Mac, use Option+Command+Esc to open Force Quit; the Windows Task Manager steps do not apply. If you must force quit, reopen Excel afterward and check for a Document Recovery pane or recovered files before continuing. Recovery may not contain every recent change, so it is not a substitute for saving.

Check the size and type of the paste

If Excel recovers, determine whether the problem happens with one particular range or with every copy-and-paste action. That distinction helps narrow down the cause. A freeze limited to one large range often points to the amount or complexity of the data; a freeze even with a few plain cells may point to an add-in, clipboard interaction, or Office problem.

Try a controlled test in a blank workbook: copy a few cells containing plain text or numbers and paste them. Then try a smaller portion of the original range. If the small test works but the original paste does not, divide the data into smaller sections or use a paste option that transfers less information.

Use Paste Values when you need the displayed results but not the formulas or source formatting. On the Home tab, open the Paste menu and choose Values.
Use Paste Special when you need a particular part of the copied cells, such as formulas or number formats, rather than everything. Available choices depend on what you copied.
When moving data between workbooks, test by copying a smaller set of rows or columns first. A full-sheet copy can also bring along formatting and other cell-level details.

These options reduce what Excel has to transfer, but they do not guarantee a fix if the workbook is busy recalculating or has another underlying problem. Also check that the selected destination is the intended size: pasting a very large copied range into a workbook with extensive formulas can create much more work than pasting the same data into a blank sheet.

Consider formulas, formatting, and calculation

A paste can trigger recalculation. This is particularly noticeable in workbooks with many formulas, formulas that depend on large ranges, data tables, or links to other workbooks. Volatile functions can recalculate more often than ordinary formulas. A workbook may therefore appear to freeze after the paste even though the slow part is updating dependent results, not copying the cells themselves.

If the workbook is usable but recalculation is the bottleneck, you can temporarily change the calculation setting in Excel for Windows: go to File > Options > Formulas, then under Calculation options select Manual. This can postpone recalculation, but it also means formula results may not update when data changes. Use it only when you understand that trade-off, and restore Automatic when you are done. Calculation mode can affect other open workbooks in the Excel session, so check the setting before relying on formula results.

Formatting can be a separate source of slowdown. Excessive conditional formatting rules, large formatted areas, and pasted formatting that extends far beyond the actual data can make a workbook harder to work with. If the slowdown follows a particular sheet, test a copy of that sheet in a new workbook rather than immediately deleting rules or clearing formatting in the only original file.

Test Excel without add-ins

An add-in can interfere with Excel or with operations involving copied data. To check for this on Windows, close Excel and open the Run dialog with Windows key+R. Type excel /safe and press Enter. Safe mode starts Excel with certain features, including Excel add-ins and startup customizations, disabled. Try a small copy-and-paste test in this mode.

If the problem does not occur in safe mode, an add-in or customization may be involved; safe mode is a diagnostic test, not a permanent repair. Open Excel normally, then go to File > Options > Add-ins. At the bottom, select COM Add-ins in the Manage box and click Go. Note which items are enabled, disable them, and restart Excel. If that resolves the issue, re-enable add-ins one at a time, restarting and testing after each change to identify the likely cause. You can also check Excel add-ins from the same Manage area.

Do not remove an add-in that your organization requires without checking with your IT administrator. Excel for Mac has different startup and add-in controls, so the Windows excel /safe command and Windows menu paths should not be used as Mac instructions. On Mac, update Excel through Microsoft AutoUpdate or the app’s available update controls, and consult your organization’s support process if managed add-ins are installed.

Check the clipboard and other open programs

The Windows clipboard is shared by Excel and other applications. Copying from or pasting into a browser, remote desktop, database, or another Office program can add another point of failure. To isolate that possibility, try copying and pasting within the same workbook, then try a simple copy from a different application. If only cross-application pastes cause trouble, test again after closing the other program or restarting Excel.

Press Esc to leave copy mode when you no longer need the copied selection. Excel also has an Office Clipboard pane, opened from the small dialog launcher in the Clipboard group on the Home tab. If the pane is open and contains many items, you can use its Clear All control to remove them. Clearing clipboard items is a troubleshooting step, not a way to recover data that was never saved.

Update or repair Microsoft 365

If small pastes freeze Excel across multiple workbooks, update Office before assuming a specific file is responsible. In Excel for Windows, go to File > Account > Update Options > Update Now, if those controls are available for your Microsoft 365 installation. Some workplace installations are managed by an administrator and may not show the same update options.

If updating does not help, close Office apps and use Windows’ installed-app repair controls. In Windows 11, open Settings > Apps > Installed apps, find Microsoft 365, select its more-options menu, and choose Modify. In Windows 10, the corresponding list is under Settings > Apps > Apps & features. A Quick Repair is a reasonable first step; if the issue continues, an Online Repair is more thorough and may require an internet connection and sign-in again. The wording can vary with the installed Office package. Save and close your work before repairing.

Prevent the freeze from returning

Once Excel is responsive, save a new copy before making major changes to the workbook. Then use a small test to identify whether the trigger is a particular range, a format-heavy paste, formulas, or an add-in. This is more informative than repeating the original large paste several times and risking another interruption.

Copy only the used cells, not entire rows, columns, or sheets when they are not needed.
Choose Values or another specific Paste Special option when full formatting and formulas are unnecessary.
Keep workbook size manageable by avoiding unnecessary formatting across whole columns and reviewing excessive conditional formatting rules.
Save a working copy before large imports, bulk edits, or changes to calculation settings.
If one file alone is consistently slow, test a copy of it and inspect the affected sheet before changing the original.

These measures reduce avoidable work, but a large workbook can still take time to process. A slow paste is not automatically evidence of a virus, a corrupted workbook, or a need to reinstall Excel. Use the pattern of the problem—one file versus every file, large versus small ranges, and safe mode versus normal startup—to choose the next step.

Frequently Asked Questions

Should I wait or force-close Excel?
Wait first if the freeze is recent or Excel appears to be processing. Force-close only when it remains unresponsive with no useful sign of progress and you accept that unsaved work may be lost. Check for recovered files when Excel reopens.

Why does Excel freeze only when I paste a large range?
A large paste can transfer formatting and formulas as well as values, and it may trigger recalculation or updates to dependent cells. Try smaller sections or Paste Values to see whether transferring less information helps.

Will switching calculation to Manual fix the freeze?
It can postpone formula recalculation in some workbooks, but it does not address every cause of a freeze. Formula results may remain out of date until recalculated, so restore Automatic when finished and verify results before using them.

Can I recover work after ending Excel in Task Manager?
Possibly. Excel may offer Document Recovery or list an unsaved workbook after reopening, but recovery is not guaranteed and may omit recent edits. Save frequently to reduce the amount of work at risk.

What if Excel freezes even when I paste a few cells?
Test in a blank workbook and in safe mode. If the problem persists across files, install available Office updates and consider repairing Microsoft 365. If it happens only in one workbook, investigate that file’s formulas, formatting, and size first.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.