How to Fix WPS Spreadsheets Freezing or Not Responding When Copying and Pasting
Question details
The user needs to troubleshoot WPS Spreadsheets freezing, turning white, or showing Not Responding during copy and paste, and prevent losing unsaved work.

- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is copying and pasting data, formulas, or formatted ranges in a spreadsheet workbook and the application stops responding.
- Observed behavior
- WPS Spreadsheets freezes, the window turns white, and the application may show Not Responding; unsaved changes can be lost.
Save the active workbook before each test, and note whether the freeze occurs in every workbook or only with specific selection sizes, content types, or add-ins.
Isolate the Freeze by Testing Selection Size, Content, and Workbook
Use this solution first to identify whether the freeze is related to the selection size, formulas, formatting, a specific workbook, or the whole WPS Spreadsheets environment.
The clipboard in spreadsheet applications can become unresponsive when a large or complex range is copied because cell data, formulas, comments, and formatting are placed on the clipboard at the same time. Narrowing the test helps you avoid losing work while you locate the trigger.
Press Ctrl+S or click the Save icon in the Quick Access Toolbar to save the workbook before each copy-paste test.
Select one cell that contains only a value, press Ctrl+C, move to another empty cell, and press Ctrl+V.
Copy and paste a small range such as 5x5 cells, then a larger range, and note the selection size where WPS Spreadsheets stops responding.
Repeat the copy-paste test with a formula cell and with a formatted range using the same destination to see whether formulas or formatting cause the freeze.
Use Ctrl+X and Ctrl+V to test Cut mode, then open a new blank workbook from File > New and repeat the copy-paste test.

Disable Unused Add-Ins and Update WPS Spreadsheets
Use this when the freeze happens in multiple workbooks or is limited to spreadsheet copy-paste, especially after installing add-ins or an update.
Use Paste Special and Clear the Clipboard for Large or Formatted Ranges
Use this when you only need values or when heavy clipboard content causes the white screen.
Fix Copy-Paste Not Responding in WPS Spreadsheets
Use WPS Spreadsheets' built-in diagnostic workflow to isolate the freeze, disable conflicting add-ins, and paste large ranges more safely with Paste Special.
- 1. Save and isolate the workbook: Open WPS Spreadsheets, load the problem workbook, and save a test copy before changing any settings.
- 2. Disable conflicting add-ins: Click the Menu icon > Settings > Add-ins, disable non-essential add-ins, and restart WPS Spreadsheets.
- 3. Use Paste Special for large ranges: Select the source range, press Ctrl+C, right-click the destination cell, choose Paste Special > Values, and click OK.
- 4. Update WPS Office: Click Menu > Help > Check for Updates, install the latest version, and restart WPS Office.
- 5. Test and save: Repeat the copy-paste operation in a new worksheet, confirm the freeze is gone, and save the workbook.

Frequently Asked Questions
Why does WPS Spreadsheets freeze only when I copy large selections?
Large or formatted selections put more data on the clipboard. Test smaller ranges and use Paste Special > Values to reduce clipboard load.
How can I recover unsaved work after a copy-paste freeze?
Restart WPS Spreadsheets and look for the Document Recovery pane or WPS Backup Center from the Menu. Save recovered files immediately.
Does copy-paste freeze more often with formulas and formatting?
Yes, formulas, comments, and formatting increase clipboard complexity. Copy plain data first, then apply formatting separately or use Paste Special.
Should I disable add-ins if WPS Spreadsheets freezes during copy-paste?
If the freeze is repeatable, open Menu > Settings > Add-ins, disable non-essential add-ins one at a time, and retest copy-paste after each change.
Can I open and edit the same Excel file in WPS Office instead?
Yes, WPS Spreadsheets opens and saves .xlsx and .xls files, preserving common formulas, formatting, and workbook structure.




