Fix Excel Freezing When Returning to a Worksheet After Copying
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.
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.
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.
Launch Excel and open the workbook that is experiencing the freezing issue.
Navigate to the sheet where the freezing typically occurs (such as your table-of-contents sheet).
Go to the 'Home' tab on the ribbon, click 'Conditional Formatting', select 'Clear Rules', and choose 'Clear Rules from Entire Sheet'.

Test with a Local Copy of the File
Network latency can cause Excel to hang if the workbook is actively syncing or stored on a slow network drive.
Use the Open and Repair Tool
High disk usage and freezing can indicate underlying file corruption that needs to be repaired.
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. Download WPS Office: Visit the official WPS website and download the free WPS Office installer.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and click 'Open' to select your existing Excel workbook.
- 3. Edit Without Interruptions: Enjoy seamless copy-and-paste functionality without experiencing crashes or freezing.

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.




