Excel Troubleshooter: Fix Excel Problems on Windows 11

Excel on Windows 11 can freeze, crash, or refuse to open, often due to corrupted settings, add-ins, or file issues. This guide shows you how to use the built-in Excel troubleshooter—actually a set of repair and diagnostic tools—to identify and fix common problems without reinstalling Office.

What You’ll Need

A Windows 11 PC with Microsoft Excel installed (Microsoft 365 or standalone Office).
Administrator access to run repair tools (you’ll be prompted).
Your Excel files backed up (optional but recommended before any repair).

Step-by-Step

Close Excel completely. Make sure no Excel windows are open, including background processes. Press Ctrl+Shift+Esc to open Task Manager, look for “Microsoft Excel” under Processes, right-click it, and choose “End task”.
Open Windows Settings. Press Win+I or click the Start button and select the gear icon.
Go to Apps. In the Settings window, click “Apps” in the left sidebar, then select “Installed apps”.
Find Microsoft 365 or Office. Scroll through the list or use the search bar to locate your Office product (e.g., “Microsoft 365” or “Microsoft Office”). Click the three-dot menu (⋯) next to it and choose “Modify”. If you don’t see “Modify”, you may need to right-click the Start button and select “Apps and Features” instead.
Choose the repair option. A User Account Control prompt may appear—click “Yes”. In the Office dialog, select “Quick Repair” (recommended first) and click “Repair”. This will attempt to fix common issues automatically. If Quick Repair doesn’t work, repeat the process and choose “Online Repair” for a deeper fix (requires internet and takes longer).
Wait for the repair to finish. The repair tool will run and may close Office apps. Let it complete—do not interrupt. After it finishes, restart Excel and see if the problem is resolved.
If the problem persists, use the built-in Excel diagnostic. Open Excel, go to “File” > “Account” (or “Help” in older versions), and look for the “Diagnose” or “Troubleshoot” button. In some versions, you’ll find it under “Help” > “Troubleshooting”. Click it to run a diagnostic that checks for common issues like corrupted files or add-in conflicts.
Check add-ins. Often, third-party add-ins cause Excel to crash. In Excel, go to “File” > “Options” > “Add-ins”. At the bottom, select “COM Add-ins” from the dropdown and click “Go”. Uncheck any suspicious add-ins, then restart Excel. If the issue disappears, re-enable them one by one to find the culprit.
Repair a specific workbook. If only one file causes problems, open Excel in Safe Mode (press Ctrl while launching Excel, or run “excel.exe /safe” from Run). If the file opens in Safe Mode, the issue is likely an add-in or customization. Alternatively, use “Open and Repair”: In Excel, go to “File” > “Open” > “Browse”, select the file, click the dropdown arrow next to “Open”, and choose “Open and Repair”.
Reset Excel preferences. If all else fails, reset Excel’s settings. Close Excel, then in File Explorer navigate to %AppData%\Microsoft\Excel. Rename the “Excel” folder to “Excel.old” (this resets user settings). Restart Excel—it will recreate the folder. Note: this removes custom settings like quick access toolbar and default fonts, but your files are safe.

Common Mistakes

Skipping Quick Repair. Some users jump straight to Online Repair, which is slower and may require a stable internet connection. Always try Quick Repair first—it fixes most issues quickly.
Not closing Excel before repair. If Excel is running, the repair tool may fail or not apply fixes correctly. Always close all Excel processes first.
Ignoring add-ins. Many “Excel problems” are actually add-in conflicts. If you skip the add-in check, you might waste time on repairs that don’t help.
Deleting files without backup. Resetting preferences or renaming folders can affect your settings. Back up your Excel files and note your custom settings before doing this.
Using the wrong repair for the wrong issue. If Excel opens but crashes on specific actions, the issue might be a corrupted file, not the program. Use “Open and Repair” on that file instead of repairing the whole Office installation.

Tips

Run the repair as administrator. Right-click the Office app in the Start menu and select “Run as administrator” before attempting repair, to avoid permission issues.
Keep Office updated. Regular updates fix known bugs. Go to “File” > “Account” > “Update Options” > “Update Now” to ensure you have the latest fixes.
Use Safe Mode for troubleshooting. Holding Ctrl while launching Excel opens it in Safe Mode, which disables add-ins and customizations. If Excel works in Safe Mode, the problem is likely an add-in or setting.
Check for conflicting programs. Some antivirus or cloud sync tools can interfere with Excel. Temporarily disable them (if safe) to see if they’re causing the issue.
Repair can take time. Online Repair may take 15-30 minutes. Don’t close the window or turn off your PC during the process.

Troubleshooting

If the repair doesn’t fix the problem, try these steps:

Run Windows Troubleshooter. Go to Settings > System > Troubleshoot > Other troubleshooters. Find “Program Compatibility Troubleshooter” and run it on Excel. This can fix issues where Excel won’t start due to compatibility settings.
Check for Windows updates. An outdated Windows 11 can cause Excel issues. Go to Settings > Windows Update and install any pending updates.
Uninstall and reinstall Office. As a last resort, uninstall Office completely (Settings > Apps > Installed apps > Microsoft 365 > Uninstall), then reinstall from your Microsoft account or installation media. This is more thorough than repair but will remove all Office apps.
If Excel still crashes, check the Event Viewer. Press Win+R, type eventvwr, and press Enter. Look under “Windows Logs” > “Application” for errors related to Excel. The error details can point to a specific DLL or add-in.

Frequently Asked Questions

Why doesn’t my Excel have a “Troubleshooter” option?

Excel doesn’t have a single button called “Troubleshooter”. Instead, you use the Office Repair tool (via Settings) and the built-in diagnostic under File > Account. If you don’t see “Diagnose”, your version may not include it—use the repair method instead.

Will repairing Excel delete my files?

No. Repair only fixes program files and settings. Your spreadsheets, macros, and data remain untouched. However, resetting preferences (step 10) will remove custom settings, not files.

How long does an Online Repair take?

It can take 15 to 30 minutes or more, depending on your internet speed and Office version. It downloads and reinstalls the entire Office suite, so it’s slower than Quick Repair.

Can I use the troubleshooter if Excel won’t open at all?

Yes. The Office Repair tool from Windows Settings works even if Excel can’t launch. For the in-app diagnostic, you’ll need to open Excel first—try Safe Mode to see if it opens.

What’s the difference between Quick Repair and Online Repair?

Quick Repair runs locally and fixes most common issues in a few minutes. Online Repair re-downloads Office files from Microsoft and fixes deeper corruption, but requires internet and takes longer.

My Excel crashes only when I open a specific file. What should I do?

Use “Open and Repair” on that file. If that doesn’t work, the file may be corrupted beyond repair—try recovering data from a backup or using a third-party recovery tool (not covered here).

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →