How to Fix Excel 2021 Excessive RAM Usage on Windows 10
Question details
Excel consumes an abnormally high amount of memory, severely impacting system performance when working with multiple files.
- Product
- Excel 2021
- Device & OS
- Windows 10
- Scenario
- Opening and working with multiple workbooks simultaneously.
- Observed behavior
- Excel 2021 uses up to 20 GB of RAM, causing a normally powerful Windows 10 computer to become extremely slow and unresponsive.
Ensure you have the login credentials for the Microsoft account associated with your Office 2021 purchase, as you will need to sign in again if a reinstallation is required.
Run the Microsoft Office Online Repair Tool
Use the built-in Windows repair tool to fix corrupted Office files that may be causing the memory leak.
Microsoft Office includes a built-in repair utility that can resolve many performance issues. While a Quick Repair is available, an Online Repair is more thorough for severe memory usage problems.
Click the Windows Start menu, type 'Control Panel', press Enter, and navigate to Programs > Programs and Features.
Locate Microsoft Office 2021 in the list of installed applications, right-click on it, and select 'Change'.
Select the 'Online Repair' option and click 'Repair'. Follow the on-screen prompts to complete the process.
Clean Uninstall and Reinstall Office 2021
If repairing Office fails to fix the RAM usage or causes license recognition errors, a clean reinstallation is the most effective solution.
Switch to WPS Office for a Lightweight, Memory-Efficient Experience
If Excel continues to drain your system's RAM, consider switching to WPS Office. It is highly optimized for performance, uses significantly less system memory, and offers seamless compatibility with Microsoft Excel formats.
- 1. Download the Installer: Visit the official WPS website and click the download button for Windows.
- 2. Install WPS Office: Run the lightweight installer to quickly set up the suite on your computer.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheet and seamlessly open your heavy Excel workbooks without the RAM drain.
Frequently Asked Questions
Why is Excel 2021 using so much RAM?
Excessive memory usage in Excel is typically caused by corrupted installation files, faulty third-party COM add-ins, overly complex array formulas, or specific software bugs in the current Office build that create a memory leak.
Will I lose my spreadsheets if I uninstall Office?
No. Uninstalling Microsoft Office only removes the application software from your system. All of your saved Excel workbooks and local documents will remain safely on your hard drive.
Why does Office ask for a Microsoft 365 subscription after repairing Office 2021?
The Online Repair process can sometimes reset local license tokens, causing Office to default to the Microsoft 365 activation prompt. Completely reinstalling Office and signing in with the Microsoft account tied to your 2021 purchase will resolve this.
How can I reduce Excel RAM usage without reinstalling?
You can try running Excel in Safe Mode by holding the Ctrl key while launching the app. If RAM usage drops, disable your COM add-ins. Additionally, clearing formatting from unused empty rows and avoiding volatile formulas like INDIRECT can help optimize memory.
