When Excel freezes while copying cells, takes a long time to save, or displays “Not Responding” with a large workbook, the cause may be the file structure, calculation load, add-ins, or memory limits. A new computer is not always the answer. Use the symptom to narrow the cause before deleting objects or changing calculation settings.
Microsoft’s Excel performance guidance covers several of the same principles: keep workbooks lean, avoid unnecessary calculations, and identify features that add overhead.
Match the freeze to the likely bottleneck
| When Excel slows down | What to investigate |
|---|---|
| Copying, pasting, or inserting rows | Conditional Formatting rules, add-ins, clipboard utilities |
| Workbook is much larger than expected | Used range extending beyond real data, formatting, embedded objects |
| Every edit triggers “Calculating” | Volatile formulas, large lookup ranges, complex dependency chains |
| Opening or saving takes a long time | File size, AutoSave, network location, data model, add-ins |
| Excel works in Safe Mode | A COM add-in or startup component may be responsible |
Fix 1: Check the used range
- Make a backup copy of the workbook.
- Open the slow worksheet and press Ctrl + End.
- If Excel jumps far beyond the actual data, inspect the extra rows and columns for formatting or stray content.
- Select only the unused trailing rows or columns, delete them if safe, save the workbook, close it, and reopen it.
In supported Microsoft 365 versions, Review → Check Performance can identify excess formatting and other workbook bloat. Availability and wording can vary by Excel version.
Fix 2: Consolidate Conditional Formatting rules
Repeated copy-and-paste operations can create duplicate rules or fragment their ranges. Open Home → Conditional Formatting → Manage Rules and choose This Worksheet from the list. If you find duplicate rules, save a backup, then consolidate them into the smallest sensible range. Avoid deleting rules that control important business reporting without confirming their purpose.
If copy-and-paste began failing after the September 2026 Excel 2016 update, check whether the installed edition and update match Microsoft’s KB5002665 release notes. The update applies to the MSI-based Excel 2016 edition; it is not a universal fix for every Microsoft 365 installation.
Fix 3: Avoid unnecessary full-column calculations
Formulas such as =XLOOKUP(E2,A:A,B:B) can make Excel consider a very large range, especially when copied down thousands of rows. Convert a dataset into an Excel Table with Ctrl + T and use structured references or bounded ranges where practical. This can reduce work during recalculation and makes formulas easier to maintain.
Fix 4: Review volatile functions
Functions such as NOW(), TODAY(), RAND(), OFFSET(), and INDIRECT() can trigger more recalculation than expected. Replace volatile formulas where an equivalent non-volatile approach works, and avoid repeating the same expensive calculation thousands of times. For example, a single helper cell containing today’s date may be easier to maintain than repeating TODAY() in every row.
Fix 5: Find hidden objects carefully
Tables copied from web pages or business systems can bring along shapes and controls. Open Home → Find & Select → Go To Special → Objects to inspect objects on the sheet. Delete them only when you know they are unwanted; charts, buttons, and form controls may be part of the workbook’s workflow. Excel versions that provide Review → Workbook Statistics can also help you inspect workbook contents.
Fix 6: Check whether you need 64-bit Excel
Open File → Account → About Excel and check whether the installed application is 32-bit or 64-bit. The 32-bit edition has a lower memory-address-space ceiling, which can be a constraint for very large data models. The 64-bit edition may help, but verify that required add-ins and integrations support it before changing Office installations.
Fix 7: Test the XLSB format on a copy
For a workbook with a large amount of data, save a copy as Excel Binary Workbook (.xlsb) and compare its size and open/save time with the original. Results vary by workbook. Keep the original until you have confirmed that macros, integrations, and any external automation work with the new format.
Fix 8: Start Excel in Safe Mode
- Close Excel.
- Press Windows + R, type
excel /safe, and press Enter. - Open the same workbook and repeat the action that normally freezes.
- If Excel is faster, open File → Options → Add-ins and disable nonessential COM add-ins one at a time, testing after each change.
Fix 9: Use Manual calculation only for a specific task
For a temporary bulk-editing job, go to Formulas → Calculation Options and choose Manual if automatic recalculation is making each edit unworkable. Press F9 to recalculate when ready. Switch back to Automatic before sharing the workbook or relying on its displayed totals; otherwise, results may remain out of date.
Frequently asked questions
Will more RAM always fix Excel?
No. A workbook with duplicate formatting rules, excessive formulas, or a problematic add-in can still be slow on a powerful computer.
Should I delete every hidden object?
No. Make a copy first and remove only objects you can identify as unnecessary.
If the issue is specifically copying and pasting after an Office update, continue with TechRankly’s Excel copy-and-paste troubleshooting guide.
