Excel Not Responding When Copying and Pasting? Fixes

How-to basics · Updated November 18, 2026

If Excel stops responding when you copy and paste, first wait a minute without clicking repeatedly; a large selection or complex workbook may still be processing. If it remains frozen, try Esc, then reopen Excel and test a smaller range in a new workbook; if the problem persists, check add-ins and update or repair Microsoft 365.

What “Not Responding” means during a paste

In Excel for Microsoft 365 on Windows, “Not Responding” usually means Windows has not received a timely response from the Excel window. It does not prove that Excel has crashed or that your workbook is damaged. Excel may be busy preparing copied cells, transferring formatting, recalculating formulas, or waiting on another component. A short pause is common with a large or complicated range; a long freeze on a small, ordinary copy deserves investigation.

Copying cells can involve more than their visible values. Excel may carry formulas, number formats, borders, conditional formatting, comments or notes, data validation, and other cell properties. The destination may also trigger recalculation or formatting work. Copying thousands of cells with complex formatting can therefore take much longer than copying a few plain values.

First, give Excel time to finish, especially if the workbook is large or stored on a network location. Avoid repeated clicks or pressing the copy and paste shortcuts over and over: these actions can queue up or replace commands and make it harder to tell whether Excel is still working. If the window becomes responsive, save the workbook before trying more troubleshooting.

Try these safe first checks

Use a small test to separate an Excel-wide issue from a workbook-specific one. Open a blank workbook, type a few words into two cells, and copy and paste them. If that works normally, the original file or the size and type of its selection may be the cause. If the blank workbook also freezes, focus on Excel, add-ins, or the Office installation.

  • Press Esc once and wait. It may cancel an active copy operation or selection, but it cannot guarantee that a calculation or other busy task will stop.
  • Try a small range rather than an entire row, column, or large block. If a small copy works, the original selection may simply be demanding.
  • When Excel responds, use Ctrl+S to save on Windows. On Mac, use Command+S.
  • If Excel stays frozen, give it more time before closing it. Ending the task can discard changes that were not saved. Excel may offer recovered files when reopened, but recovery is not guaranteed.

On a Mac, the same general checks apply, but use Command+C and Command+V for copying and pasting. If Excel is completely unresponsive, use the Apple menu to open Force Quit rather than Windows Task Manager. Excel for the web runs in a browser, so browser performance and clipboard permissions can also affect copying.

Check whether the selection is too large

A common cause is copying far more cells than the visible data requires. Selecting a whole worksheet column with Ctrl+Space or an entire row with Shift+Space can mean tens of thousands of cells, even if only a few contain data. Large ranges with formulas, conditional formatting, or elaborate borders can take additional time to copy and paste.

Choose only the cells you need. If you are copying a data table, select its actual used range rather than whole columns. Ctrl+End moves to the last cell Excel considers used, although old formatting can make that cell much farther down or to the right than the visible data. If Ctrl+End lands unexpectedly far away, the workbook may contain leftover formatting; save a copy before removing unused rows, columns, or formats.

For a large transfer, try one of these approaches:

  • Copy a smaller section first. If that succeeds, work in manageable blocks rather than repeating the full-range operation.
  • Use Paste Special to transfer only what is needed. On Windows, copy the cells, choose Home > Paste > Paste Special, and select an option such as Values. This avoids carrying over some formatting and formulas.
  • If only the displayed results are needed, paste values instead of formulas. This can reduce recalculation in the destination, but it removes the formulas that generated those results.
  • When possible, avoid copying large blocks of repeated formatting. Applying a simple format to the destination may be quicker than transferring extensive styles cell by cell.

These techniques are not a cure for every freeze. If even a small selection hangs, move on to testing the workbook and Excel itself.

Find out whether the workbook is the problem

If copying works in a blank workbook but not in one particular file, inspect that file before changing Excel settings. Save a separate copy so you can test safely. Try copying a small group of cells from another sheet, then try the affected sheet. A problem limited to one sheet can point to extensive formatting, complex formulas, or a particular object or feature on that sheet.

Workbook size alone does not identify the cause. A smaller workbook can still be slow if it contains many formulas, conditional formatting rules, external links, or objects. Volatile formulas and formulas that refer to large ranges may also contribute because editing or pasting can prompt recalculation. If the workbook is shared, stored on a network, or synchronized through a cloud service, test a local copy when permitted; this helps distinguish workbook processing from a slow connection.

If the file may be damaged, close it and make another backup before trying recovery. In Excel for Windows, use File > Open > Browse, select the workbook, choose the arrow beside the Open button, and select Open and Repair. This option may help with certain file problems, but it is not a general performance fix and cannot guarantee that every issue will be repaired.

When only one workbook is affected, do not immediately delete its formulas or formatting. First identify whether the delay occurs on a specific sheet, with a particular range, or after a particular paste. Those details can narrow the cause without changing important data.

Test Excel in Safe Mode and check add-ins

An add-in can interfere with Excel even if it does not appear to be related to copying. To test this on Windows, close Excel, press Windows key+R, type excel /safe, and press Enter. Safe Mode starts Excel with many customizations and add-ins disabled. Open a copy of the affected workbook and try a small copy and paste.

If the problem disappears in Safe Mode, an add-in or startup customization is a likely contributor. Close Safe Mode, then in normal Excel go to File > Options > Add-ins. At the bottom, use the Manage list to select COM Add-ins and click Go. Clear the check boxes to temporarily disable the listed COM add-ins, restart Excel, and test again. You can re-enable them one at a time to identify a conflict. Other add-in types may appear in the Manage list, so test those separately if needed.

Do not remove an add-in permanently just because disabling it changes the behavior. It may be needed for a work process. If the workbook belongs to an organization, ask the person who manages its add-ins before changing required settings. Safe Mode is a diagnostic test, not a permanent way to use Excel.

Consider calculation and workbook complexity

Pasting cells can make Excel recalculate formulas, and a complex workbook may appear frozen while calculation runs. Look for a calculation indicator in the status bar if Excel is responsive. If the pause happens after pasting formulas or values into a formula-heavy workbook, calculation load may be part of the issue rather than the clipboard itself.

Excel’s calculation setting is available at Formulas > Calculation Options. Automatic is the usual setting for ordinary workbooks. Switching to Manual can reduce repeated recalculation during some tasks, but it can leave displayed results out of date until you calculate again. It can also affect other open workbooks, so do not use it as a casual fix. If you change it for a specific task, restore Automatic afterward and confirm that the workbook has recalculated.

Other workbook features can add work during a paste. For example, a paste into cells covered by numerous conditional formatting rules may require Excel to evaluate those rules. A destination with merged cells or a filtered range can also produce paste errors or unexpected results. These situations often cause a warning or rejected paste rather than a true application freeze, so note the exact message and distinguish it from a window that genuinely stops responding.

Update or repair Microsoft 365

If the issue happens in multiple workbooks and also occurs in Safe Mode, update Office and test again. In Excel for Windows, go to File > Account > Update Options > Update Now. Install available updates, restart Excel, and retry the copy operation. Menu wording can vary slightly by update channel or organization-managed installation; some workplaces control when Office updates are installed.

If updating does not help, Windows can repair Microsoft 365. Close Office apps, then open Windows Settings and go to Apps > Installed apps. Find Microsoft 365, choose its menu, select Modify, and try Quick Repair first. If the problem remains, Online Repair is a more thorough option and may require an internet connection and a longer wait. The labels differ somewhat between Windows versions. Repairing Office is different from repairing a particular workbook, so keep a backup of important files as a sensible precaution.

If Excel freezes across several files after these steps, note when it began, whether other Office apps are affected, and whether the computer is also short on memory or storage. That information can help your organization’s IT support narrow the problem. Avoid downloading unofficial “Excel repair” tools or disabling security software as a first response.

Reduce the chance of another freeze

For routine work, keep selections limited to the cells you need and avoid carrying unnecessary formatting into large destinations. Save important work before a large paste, particularly in a workbook with extensive formulas or external links. If you regularly move large datasets, importing or transforming the data with Excel’s built-in tools may be more suitable than copying a massive formatted range between sheets.

When you troubleshoot, change one thing at a time: test a blank workbook, reduce the selection, try Safe Mode, then investigate the affected file. This makes it easier to find the actual cause and undo a change that does not help. Keep an untouched backup before altering workbook structure or attempting repair.

Frequently Asked Questions

Why does Excel freeze when I copy a large range?
Excel may be preparing values, formulas, formatting, and other cell properties for the clipboard. Large selections and complex workbooks can take time, especially if the paste also triggers recalculation. Try a smaller range or paste values when formulas and formatting are not needed.

Should I end Excel in Task Manager when it says Not Responding?
Not immediately. Wait to see whether Excel finishes, because ending the task can lose unsaved changes. If it remains unresponsive and you decide to close it, reopen Excel and check for a Document Recovery pane, but do not assume every unsaved change can be recovered.

Why does copy and paste work in a new workbook but not my file?
The affected workbook may have complex formatting, formulas, external links, or a problem limited to one sheet or range. Test a copy of the file, narrow down the sheet and selection involved, and consider Open and Repair only if you suspect file damage.

Can an Excel add-in make copying and pasting freeze?
Yes, an add-in can affect Excel’s behavior. Start Excel in Safe Mode on Windows with excel /safe. If copying works there, disable add-ins temporarily through File > Options > Add-ins and test them one at a time.

Does Excel calculate formulas again after I paste?
It can. Pasting into a workbook with dependent formulas may trigger recalculation, which can make Excel slow to respond. Check the calculation setting at Formulas > Calculation Options, but remember that Manual calculation can leave results out of date.

Related

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.