How to Fix Microsoft Excel Not Working Properly
When Microsoft Excel starts freezing, crashing, or failing to respond to your commands, it can completely halt your workflow. Fortunately, most performance issues stem from corrupted cache files, conflicting third-party add-ins, or an outdated Office installation that can be resolved in just a few minutes.
This troubleshooting guide walks you through the most effective methods to diagnose why Microsoft Excel is not working properly and restore normal functionality on your Windows or Mac computer without losing your valuable data.
Open Excel in Safe Mode to Identify Add-in Conflicts
The quickest way to figure out why Microsoft Excel is not working properly is to launch the application in Safe Mode. Safe Mode starts Excel without loading any extensions, macros, or startup files, allowing you to determine if a third-party add-in is causing the application to crash or freeze.
To open Excel in Safe Mode on Windows, press the Windows Key + R to open the Run dialog box, type excel /safe, and press Enter. If you are using a Mac, open the Terminal app from your Applications folder or via Spotlight, type open -a Microsoft\ Excel --args -safemode, and press Return. If Excel opens and functions normally without freezing, you have successfully narrowed down the culprit to a faulty add-in or corrupted preference file.
Disable Faulty Add-ins Causing Freezes
If Excel runs smoothly in Safe Mode, a COM add-in or Excel add-in is almost certainly the root cause of your performance troubles. Disabling these extensions is a straightforward process that takes less than two minutes and immediately restores application stability.
Open Excel normally, click on File > Options > Add-ins. At the bottom of the window, make sure the Manage dropdown is set to COM Add-ins, then click Go. Uncheck all active add-ins in the list and click OK. Restart Excel normally. If the application works without issues, turn the add-ins back on one by one, testing after each change, until you find the specific extension that is breaking your spreadsheet environment.
Repair Your Microsoft Office Installation
When core system files associated with Microsoft Office become corrupted, multiple applications including Excel may stop responding or refuse to open entirely. Running the built-in Microsoft Office repair utility will scan for damaged files and automatically replace them with fresh copies from your system or the cloud.
On Windows, open the Start menu and go to Settings > Apps > Installed Apps (or Apps & Features). Scroll down to locate Microsoft 365 or your specific Office suite, click the three dots menu next to it, and select Modify. Choose Quick Repair first, as this resolves most minor issues without needing an active internet connection. If that does not work, run the more thorough Online Repair option. For Mac users, uninstalling Office completely and downloading a fresh installer from your Microsoft account page serves as the equivalent fix.
Clear Excel Cache and Temporary Files
Over time, accumulated temporary files, auto-recovery backups, and corrupted cache data can bloat your system and cause Excel to lag, freeze up during saving, or fail to calculate complex formulas. Clearing out this unnecessary data frees up resources and gives the program a clean slate.
On Windows, press Windows Key + R, type %temp% and press Enter. Look for temporary files starting with Microsoft Excel or Office and delete them. Additionally, check your default Excel template files located in the AppData roaming folder and remove any corrupted XLStart contents. On macOS, navigate to Library > Containers > com.microsoft.Excel > Data > Library > Caches and clear out the cached files.
Update Microsoft Excel to the Latest Version
Running an outdated version of Excel leaves you vulnerable to known software bugs, memory leaks, and compatibility issues with newer operating system updates. Microsoft regularly pushes patches that address crashing bugs and performance slowdowns.
To update Excel on Windows, open any Office application like Word or Excel, click File > Account (or Office Account), click Update Options, and select Update Now. If you downloaded Excel through the Microsoft Store, open the Microsoft Store app, go to Library, and click Get updates. On Mac, open Excel, click Help > Check for Updates, and let Microsoft AutoUpdate install any pending patches.
Check for Operating System File Corruption
If Excel continues to crash despite trying all software-level troubleshooting steps, the issue might be rooted deeper within your operating system's core system files. Damaged Windows system components or macOS file permissions can prevent applications from executing properly.
On Windows, right-click the Start button and select Terminal (Admin) or Command Prompt (Admin). Type sfc /scannow and press Enter to let the System File Checker scan and repair damaged files. Restart your computer once the scan finishes. On Mac, open Disk Utility from your Applications folder, select your startup drive, and click First Aid to verify and repair disk permission errors.
The bottom line
Dealing with an unresponsive spreadsheet application can be frustrating, but working systematically through Safe Mode, add-in checks, Office repairs, and cache clearances will almost always resolve the issue. Once you identify and fix the underlying conflict, Excel will return to its usual fast and reliable performance.
Frequently asked questions
Why does Excel freeze every time I open a specific file?
If Excel only freezes on one particular file, the spreadsheet itself is likely corrupted or contains heavy macros, external links, or broken formulas. Try opening Excel in Safe Mode first, then open the file from within the app while holding the Shift key to bypass external links.
How do I recover unsaved work if Excel crashes?
Excel has a built-in AutoRecover feature. Reopen Excel after a crash, and a Document Recovery pane should appear on the left side showing your unsaved files. You can also manually check the folder path specified under File > Options > Save > AutoRecover file location.
Does reinstalling Microsoft Office delete my spreadsheets?
No, uninstalling and reinstalling Microsoft Office only removes the application files and program binaries. Your personal Excel spreadsheets, documents, and workbook data are stored separately in your Documents folder and will remain safe.
Why is Excel running extremely slowly on my computer?
Slow performance is often caused by excessive conditional formatting, too many background calculation processes, hardware acceleration conflicts, or running out of RAM. Try disabling hardware acceleration in Excel options and closing resource-heavy background apps.
Can antivirus software interfere with Microsoft Excel?
Yes, aggressive third-party antivirus programs or ransomware protection settings can block Excel from writing temporary files or saving work. Temporarily disable your third-party security software or add Excel to its exclusion list to test if it resolves the problem.
