'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel Stuck on "Working on It" When Pasting Data
Question details
The user is experiencing severe performance issues where Excel freezes and displays a continuous processing prompt when attempting to paste data.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Pasting data within the same spreadsheet or across different workbooks.
- Observed behavior
- Excel becomes unresponsive and repeatedly displays the message "Working on it... Excel is processing your last request..." instead of completing the paste operation.
Ensure you save any open workbooks and check that your device has all the latest Windows updates installed, as pending system updates can cause temporary performance glitches in Office apps.
Run Excel in Safe Mode and Disable Add-ins
Starting Excel in Safe Mode bypasses add-ins. If pasting works fine in Safe Mode, a third-party add-in is likely causing the freeze.
COM add-ins and third-party extensions are common culprits for Excel performance issues. Disabling them one by one helps identify the exact add-in causing the problem.
Press the Windows key + R to open the Run dialog. Type 'excel /safe' (without quotes) and press Enter to open Excel in Safe Mode.
Try copying and pasting data. If Excel does not get stuck, proceed to the next step to disable your add-ins.
Go to 'File' > 'Options' > 'Add-ins'. At the bottom of the window next to 'Manage', select 'COM Add-ins' and click 'Go'.
Uncheck all add-ins in the list and click 'OK'. Restart Excel normally. Re-enable the add-ins one by one to determine which one is causing the freezing issue.
Disable Hardware Graphics Acceleration
Turning off hardware graphics acceleration can resolve freezing and display issues when rendering animations or processing heavy actions like pasting.
Run an Office Repair
Repairing your Microsoft Office installation fixes corrupted system files that may be causing the application to hang during basic operations.
Switch to WPS Office for a Faster, Freeze-Free Spreadsheet Experience
If Microsoft Excel continues to freeze and display the 'Working on it' error during simple tasks, consider switching to WPS Office. It is a highly optimized, lightweight alternative that handles heavy copy-paste operations seamlessly without consuming excess system resources.
- 1. Download the Installer: Visit the official WPS Office website and click the free download button to get the setup file.
- 2. Install WPS Office: Run the downloaded installer and follow the quick on-screen instructions to set up the software.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets. You can instantly open, edit, and paste data into your existing Excel (.xlsx) workbooks smoothly.
Frequently Asked Questions
Why does Excel take so long to paste data?
Excel may take a long time to paste data due to conflicting COM add-ins, heavy conditional formatting applied to the target cells, corrupted Office installation files, or a full Office clipboard.
Can clearing the Office Clipboard help with pasting issues?
Yes. A bloated clipboard can cause performance issues. To clear it, click the small launcher arrow in the bottom-right corner of the Clipboard group on the Home tab, then click 'Clear All'.
Does conditional formatting cause Excel to get stuck?
Yes, pasting data over a large range of cells that contain overlapping or complex conditional formatting rules forces Excel to recalculate, which can trigger the 'Working on it' freeze. Pasting as 'Values Only' can prevent this.
What should I do if Safe Mode doesn't fix the problem?
If Excel still freezes in Safe Mode, the issue is not caused by add-ins. You should proceed to disable hardware graphics acceleration, ensure Windows and Office are fully updated, or perform a Quick Repair of your Office installation.
