Excel Performance Problems

How to Fix WPS Spreadsheets Freezing or Not Responding When Copying and Pasting

Natalie TaylorNatalie Taylor Nov 13, 2026 870 views

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.

Fix WPS Spreadsheets Freezing or Not Responding When Copying and Pasting
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.
Before you start

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.

Solution 1Recommended

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.

1
Save the active workbook

Press Ctrl+S or click the Save icon in the Quick Access Toolbar to save the workbook before each copy-paste test.

2
Test a small plain-data copy

Select one cell that contains only a value, press Ctrl+C, move to another empty cell, and press Ctrl+V.

3
Increase the selection gradually

Copy and paste a small range such as 5x5 cells, then a larger range, and note the selection size where WPS Spreadsheets stops responding.

4
Compare formulas and formatting

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.

5
Test Cut and Paste and a new workbook

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.

Isolate the Freeze by Testing Selection Size, Content, and Workbook
What this tells you: If small plain-data copies work but large formatted ranges freeze, use Paste Special or split the range. If every copy-paste freezes, move to the add-in and update steps.

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. 1. Save and isolate the workbook: Open WPS Spreadsheets, load the problem workbook, and save a test copy before changing any settings.
  2. 2. Disable conflicting add-ins: Click the Menu icon > Settings > Add-ins, disable non-essential add-ins, and restart WPS Spreadsheets.
  3. 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. 4. Update WPS Office: Click Menu > Help > Check for Updates, install the latest version, and restart WPS Office.
  5. 5. Test and save: Repeat the copy-paste operation in a new worksheet, confirm the freeze is gone, and save the workbook.
Full compatibility with Microsoft Excel .xls and .xlsx files so you can move the same workbooks without conversion.Free, lightweight spreadsheet editor that reduces system load compared with traditional Excel installations.Familiar ribbon and menu layout minimizes the learning curve when switching from Microsoft Excel.Built-in Paste Special options help you copy large data ranges without carrying excess formatting.
microsoft office alternative - wps office

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.