Forum Discussion
Why is Excel suddenly calculating much slower than before?
I've noticed that one of my workbooks has become significantly slower over the past few weeks. It's around 20 MB, contains several PivotTables, XLOOKUP formulas, and conditional formatting.
Simple edits now take a few seconds before Excel responds, even though my PC isn't under heavy load.
Has anyone experienced something similar? Are there any common settings or features that typically cause this kind of slowdown?
Any suggestions would be appreciated.
3 Replies
Check Formulas > Calculation Options. Make sure it is not stuck on something unusual. Try Manual temporarily to test.
Check for heavy formulas. XLOOKUP over whole columns like A:A can slow things down. Use limited ranges or Excel Tables.
Reduce conditional formatting. Home > Conditional Formatting > Manage Rules. Delete duplicate/unused rules and avoid applying rules to entire columns.
Refresh/rebuild PivotTables. Old pivot caches can make files larger and slower.
Check file bloat. Press Ctrl + End. If Excel jumps far below/right of your real data, clear unused rows/columns and save.
Disable add-ins temporarily. File > Options > Add-ins.
Save as a new .xlsx file. Sometimes this cleans hidden workbook bloat.
Worth taking a look at this, learn.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-tips-for-optimizing-performance-obstructions
I've run into this a few times. Before diving deep, I'd check whether the slowdown is specific to the workbook or to Excel in general.
A few common causes:
- Excessive conditional formatting (especially if applied to entire columns)
- XLOOKUPs referencing large ranges or entire columns
- PivotTables connected to large datasets
- Volatile formulas (OFFSET, INDIRECT, TODAY, RAND, etc.)
- Hidden sheets, named ranges, or objects that have accumulated over time
- Workbook corruption/bloat from years of edits, copy/paste operations, and saved history
One quick test is to save a copy under a new name and see whether performance changes. I've also seen cases where recreating the workbook structure in a fresh file significantly improved responsiveness.
Other useful checks:
- Set calculation to Manual and see if the lag disappears.
- Check Conditional Formatting Rules Manager for duplicate or oversized rules.
- Review Name Manager for obsolete named ranges.
- Check workbook size versus actual used range (Ctrl+End on each sheet).
- Try opening the file on another PC to determine whether the issue follows the workbook.
If the slowdown appeared gradually over weeks rather than immediately after a large change, I'd personally suspect workbook bloat, conditional formatting, or formulas referencing larger ranges than intended.
