Quick fixes when Excel crashes on copy: (1) open Excel in safe mode: Windows + R, type excel /safe; if copying works there, an add-in is to blame, so go to File > Options > Add-ins > Manage COM Add-ins > Go and untick them one at a time; (2) turn off graphics acceleration: File > Options > Advanced > Display > tick Disable hardware graphics acceleration; (3) paste with Paste Values (Ctrl + Alt + V) instead of pasting full formatting; (4) clear the excess used range (if Ctrl + End jumps far beyond your data, delete the empty rows and columns and save); (5) update Office and the graphics driver; (6) repair Office: Settings > Apps > Microsoft 365 > Modify > Quick Repair.
Excel crashing when you copy data is a common problem that disrupts daily work. This article explains the causes and gives effective steps to fix it.
Common causes of Excel crashing when copying data
1. The workbook is too large or complex
If the workbook is very large or holds a lot of data, formulas or formatting, Excel can struggle. Copying a big range can overload it and cause a crash.
2. Conflicts with other applications
Other programs running alongside Excel can cause conflicts, especially those that use a lot of resources or hook into the clipboard (clipboard managers, remote desktop tools, screen-capture apps).
3. Add-ins
Installed add-ins can cause problems, especially outdated ones or those not compatible with your version of Excel. Check and remove add-ins you do not need.
4. Outdated printer drivers
Excel uses the default printer driver for page layout, so a faulty or outdated printer driver can make it unstable. Keep printer drivers up to date.
5. A corrupted workbook
A damaged file can make Excel unstable. If you suspect corruption, try opening it on another computer or use Excel’s repair tool.
6. Outdated Excel
Older versions can have bugs that have since been fixed. Make sure Excel is fully updated.
7. Not enough RAM
Excel needs enough memory to work well. Without it, heavy tasks such as copying large ranges can crash Excel.
Step-by-step fixes
Important: always back up your data before making changes.
1. Restart Excel and your computer
The simplest first step. A restart often clears temporary problems.
2. Update Excel
Go to File > Account > Update Options > Update Now. Updates fix many bugs.
3. Disable unnecessary add-ins
Go to File > Options > Add-ins and disable add-ins you do not use, to reduce conflicts.
4. Repair the workbook with the built-in tool
Go to File > Open, select the file, click the arrow next to Open and choose Open and Repair.
5. Update or reinstall the printer driver
Download the latest driver from the printer manufacturer’s website, or uninstall the current one if necessary. As a test, set “Microsoft Print to PDF” as the default printer.
6. Check and free up RAM
Use Task Manager to close applications you do not need, freeing memory for Excel.
7. Copy data in smaller chunks
If you are copying a large amount of data, split it and copy one part at a time.
8. Use Paste Special
Use Paste Special (for example Values only) to avoid pasting heavy formatting and reduce the chance of a crash.
9. Disable hardware graphics acceleration
Go to File > Options > Advanced, find Display and tick Disable hardware graphics acceleration to rule out graphics card problems. (This option is not shown in some newer Microsoft 365 builds.)
10. Check for system errors
If nothing else helps, run System File Checker (sfc /scannow) to find corrupted system files, and run an Office Quick or Online Repair.
Preventing Excel crashes when copying
1. Clean up and optimise workbooks regularly
Remove unused cells and ranges, and avoid overly complex formatting.
2. Remove unnecessary formatting
Too much formatting (especially thousands of conditional formatting rules or cell styles) makes workbooks heavy. Check and remove what you do not need.
3. Split very large workbooks
Consider splitting very large files into several smaller ones, or moving raw data into Power Query or a database.
4. Make sure your computer meets the requirements
Check Excel’s system requirements; for large workbooks, 16 GB of RAM and 64-bit Office are recommended.
5. Use licensed, up-to-date Excel
Licensed, regularly updated Office gets the latest fixes and features.
6. Manage add-ins carefully
Install only add-ins you need and keep them updated.
Conclusion
Excel crashing on copy can be very disruptive, but by identifying the cause and applying the fixes above you can usually solve it. If you have tried everything and the problem persists, contact IT Systems at hotline 028.3995.03.59 or contact@itsystems.com.vn.
Use licensed Office to get official updates and fixes
- Office Home 2024 – Word, Excel, PowerPoint, 1 PC, perpetual · VND 2,950,000
- Office Home & Business 2024 – adds Outlook, licensed for business, 1 PC · VND 5,500,000
- Microsoft 365 Business Standard – always-updated Office + email + OneDrive, per user · VND 3,550,000/user/year
Not sure which to pick? See Office 2024 vs Microsoft 365. Prices excl. VAT, from IT Systems Store, Nov 2026.
FAQ
Why does Excel freeze or close when copying data?
The file is large or heavily formatted, an add-in conflicts, another app holds the clipboard, the default printer driver is faulty or Office is outdated.
How do I find the add-in causing it?
Start Excel in safe mode (hold Ctrl when opening or run excel /safe). If the problem stops, disable add-ins one by one under File > Options > Add-ins.
How can I copy large data between files reliably?
Paste as Values (Paste Special > Values), copy smaller ranges and use Power Query instead of manual copying for large volumes.
Email or Outlook problems across your team?
IT Systems deploys Microsoft 365, migrates email, sets up security and supports users on Outlook, Teams and OneDrive.



