Office Apps Freezing

Fix Excel Freezing When Returning to a Worksheet After Copying

John WilsonJohn Wilson Oct 22, 2026 873 views

Question details

Excel becomes unresponsive or freezes when navigating back to a table-of-contents sheet or another worksheet after copying and pasting content.

Product
Microsoft Excel
Device & OS
not provided
Scenario
Copying data from one section of a workbook and returning to a main sheet or table of contents to paste or review.
Observed behavior
The application hangs, stops responding, or crashes entirely, often accompanied by high disk and memory usage in the system.
Before you start

Check your system's Task Manager to monitor Excel's memory and disk usage, and verify if the file is currently stored on a remote network drive or cloud folder.

Solution 1Recommended

Clear Excessive Conditional Formatting

Too many conditional formatting rules can heavily bloat the workbook, causing Excel to freeze during copy-and-paste operations.

When you repeatedly copy and paste data across a workbook, conditional formatting rules are often duplicated. Over time, this creates thousands of overlapping rules that exhaust system memory when switching sheets.

1
Open the Workbook

Launch Excel and open the workbook that is experiencing the freezing issue.

2
Select the Problematic Sheet

Navigate to the sheet where the freezing typically occurs (such as your table-of-contents sheet).

3
Clear Formatting Rules

Go to the 'Home' tab on the ribbon, click 'Conditional Formatting', select 'Clear Rules', and choose 'Clear Rules from Entire Sheet'.

Clear Excessive Conditional Formatting
Data Safety: Clearing conditional formatting will only remove dynamic visual styles (like cell colors based on values) and will not delete any actual data or formulas.
Free Microsoft Office alternative

Avoid Freezing Issues with WPS Office

If Microsoft Excel continues to hang or consume too much memory during standard copy-paste tasks, consider switching to WPS Office. It is a highly optimized, lightweight productivity suite designed to handle complex datasets and formatting without taxing your system.

  1. 1. Download WPS Office: Visit the official WPS website and download the free WPS Office installer.
  2. 2. Open Your Spreadsheets: Launch WPS Spreadsheets and click 'Open' to select your existing Excel workbook.
  3. 3. Edit Without Interruptions: Enjoy seamless copy-and-paste functionality without experiencing crashes or freezing.
Smooth performance for large datasets and heavy copy-paste operations.Fully compatible with Microsoft Excel file formats (.xlsx, .xls, .csv).Lightweight application that requires minimal memory and disk resources.Free to use with a familiar, tabbed user interface for easy navigation.
QA img-9

Frequently Asked Questions

Why does Excel freeze only when I copy and paste data?

Copying and pasting transfers not just raw text, but also complex formatting, formulas, and data validation rules. If your workbook has excessive conditional formatting or hidden objects, the clipboard can become overloaded, causing the program to freeze.

Can working on a network drive cause Excel to stop responding?

Yes. If your workbook is stored on a shared network drive, brief interruptions in network connectivity or latency while syncing the newly pasted data can cause Excel to hang. Moving the file to a local drive temporarily can help isolate the problem.

How do I fix a corrupted Excel file that keeps freezing?

You can repair a corrupted file by launching Excel, navigating to File > Open, locating your file, and clicking the drop-down arrow next to the Open button to choose the 'Open and Repair' option.