How to Fix Microsoft 365 Excel Freezing and High CPU Memory Usage
Question details
Microsoft 365 Excel freezes and consumes 100% memory and high CPU when working with large workbooks.
- Product
- Microsoft 365 Excel
- Device & OS
- Windows 11
- Scenario
- Working with a large estimating workbook containing complex data on a new laptop.
- Observed behavior
- Excel becomes completely unresponsive, with Task Manager showing abnormally high CPU usage and memory consumption reaching 100 percent, even after removing objects and macros.
Before troubleshooting, open the Windows Task Manager (Ctrl + Shift + Esc) to verify the resource usage and force close Excel if it is completely unresponsive.
Run Excel in Safe Mode to Identify Add-in Conflicts
Starting Excel in Safe Mode bypasses features and settings such as alternative startup locations, customized toolbars, and third-party add-ins that often cause severe memory leaks.
If your large workbook functions normally in Safe Mode, the high CPU and memory usage is almost certainly caused by an incompatible or outdated COM add-in running in the background.
Press the Windows key + R on your keyboard to open the Run dialog box.
Type 'excel /safe' into the text box and press Enter to open Excel in Safe Mode.
Open the problematic estimating workbook. Check if the freezing and high resource usage persist.
If performance improves, go to File > Options > Add-ins. At the bottom of the window, select 'COM Add-ins' from the Manage drop-down menu and click Go. Uncheck all listed add-ins and restart Excel normally to resolve the conflict.
Install the Latest Microsoft 365 Updates
Performance bugs causing memory leaks or high CPU spikes are frequently patched by Microsoft in their regular Office updates.
Isolate File Corruption and Storage Issues
Determine if the freezing issue is isolated to a corrupted file, or if network latency from cloud synchronization is overwhelming your system resources.
Try WPS Office for a Faster, Lightweight Spreadsheet Experience
If Microsoft Excel continues to freeze or consume excessive system resources, consider switching to WPS Office. WPS Spreadsheet is a highly optimized, lightweight alternative that handles large datasets efficiently without draining your CPU or memory.
- 1. Download WPS Office: Visit the official WPS website and download the free, lightweight installation package.
- 2. Install and Launch: Run the installer and launch WPS Spreadsheet on your Windows 11 laptop.
- 3. Open Your Workbook: Drag and drop your large estimating workbook directly into WPS Spreadsheet to experience smooth, lag-free editing.
Frequently Asked Questions
Why is Excel using 100% of my memory on a new Windows 11 laptop?
High memory usage in Excel is typically caused by volatile formulas calculating constantly, bloated file sizes from excessive hidden formatting, corrupted COM add-ins running in the background, or an unpatched memory leak bug in your current Microsoft 365 build.
Does disabling macros fix Excel freezing issues?
Poorly written VBA macros can trigger infinite loops that completely freeze Excel. However, if you have already removed macros and objects but the high CPU and memory usage persists, the root cause is likely an add-in conflict, file corruption, or outdated software.
How do I stop Excel from freezing every time I type data into my workbook?
If your large workbook freezes during data entry, switch your calculation settings to manual. Go to the Formulas tab, click Calculation Options, and select Manual. Excel will stop updating volatile cells automatically, and you can press F9 to calculate the workbook only when you are ready.
