Fix Excel Not Responding: Step-by-Step Guide

Microsoft Excel freezing or showing “Not Responding” can halt your work and risk losing unsaved data. This guide walks you through safe, effective fixes—from simple recovery steps to deeper repairs—so you can get Excel running smoothly again without losing your files.

What You’ll Need

• Access to Windows (or macOS if noted) with administrator privileges
• Your Excel file location (if you need to recover it)
• Patience—some steps require waiting for Excel to respond

Step-by-Step

1. Wait and check for a response. Sometimes Excel is just processing a large calculation or opening a big file. Wait 30–60 seconds. If the title bar still says “Not Responding,” proceed.
2. Try to save your work. If the window is partially responsive, press Ctrl+S (or Cmd+S on Mac) to save. If it saves, close Excel normally and reopen. If not, continue.
3. Force-quit Excel. Press Ctrl+Shift+Esc to open Task Manager (Windows). Find “Microsoft Excel” in the Processes tab, select it, and click “End Task.” On Mac, press Cmd+Option+Esc, select Excel, and click “Force Quit.” This will lose any unsaved changes, but it’s the only way to close a truly frozen app.
4. Reopen Excel in Safe Mode. Hold the Ctrl key (Windows) or Option key (Mac) while launching Excel. If it opens in Safe Mode, the problem is likely caused by an add-in or a setting. If Excel opens normally, skip to step 6.
5. Disable add-ins. In Excel, go to File → Options → Add-ins. At the bottom, select “COM Add-ins” from the Manage dropdown and click “Go.” Uncheck all add-ins, then click OK. Restart Excel normally. If it works, re-enable add-ins one by one to find the culprit.
6. Repair Office installation. Go to Control Panel → Programs and Features (or Settings → Apps). Find Microsoft Office, select it, and click “Change.” Choose “Quick Repair” first; if that doesn’t help, try “Online Repair” (requires internet). This fixes corrupted files that can cause freezing.
7. Check for large or corrupted files. If the issue only happens with a specific workbook, the file may be corrupted. Try opening it in Excel’s built-in repair: File → Open → select the file → click the arrow next to “Open” → choose “Open and Repair.” If that fails, try opening the file in Google Sheets or a text editor to recover data.
8. Update Excel and Windows. Go to File → Account → Update Options → Update Now. Also check Windows Update in Settings. Outdated software can cause compatibility issues.
9. Clear Excel’s temporary files. Press Win+R, type %temp%, and press Enter. Delete any files that start with “Excel” or “~” (tilde). On Mac, go to ~/Library/Containers/com.microsoft.Excel/Data/Library/Caches and delete the contents.
10. Check for conflicting software. Antivirus, cloud sync tools (OneDrive, Dropbox), or other Office add-ins can interfere. Temporarily disable your antivirus (if safe) and see if Excel works. If it does, add Excel to the exception list.

Common Mistakes

• Not waiting long enough. Large files with complex formulas can take minutes. Give Excel a fair chance before force-quitting.
• Force-quitting without trying to save. Always attempt to save first; you might lose hours of work otherwise.
• Skipping Safe Mode. Safe Mode is the fastest way to isolate add-in issues. Skipping it can lead to unnecessary reinstalls.
• Ignoring updates. Running an outdated Excel version is a common cause of freezes. Always update first.
• Deleting temp files while Excel is running. This can cause further corruption. Close Excel completely first.

Tips

• Enable AutoRecover. Go to File → Options → Save and set “Save AutoRecover information every” to 5 minutes. This minimizes data loss if Excel crashes.
• Use the 64-bit version of Office. If you have a 32-bit version, it can only use 4GB of RAM. The 64-bit version handles larger files better.
• Split large workbooks. If a file is over 50MB or has thousands of formulas, consider splitting it into smaller files to reduce strain.
• Keep your system clean. Regularly close unnecessary programs to free up RAM and CPU for Excel.
• Disable hardware graphics acceleration. Go to File → Options → Advanced → under Display, check “Disable hardware graphics acceleration.” This helps on some systems.

Troubleshooting

If the above steps don’t fix the issue, try these additional checks:

• Check for external data connections. If your workbook pulls data from external sources (e.g., SQL, web), the connection may hang. Go to Data → Queries & Connections and see if any are stuck. Remove or refresh them.
• Run a full system virus scan. Malware can cause Excel to freeze. Use Windows Defender or your preferred antivirus.
• Create a new user profile. Sometimes your Windows user profile is corrupted. Test by creating a new local user and opening Excel there. If it works, migrate your files.
• Check for printer drivers. Excel sometimes freezes when a printer driver is faulty. Try setting a different default printer (or a virtual PDF printer) and see if the issue resolves.
• Reinstall Microsoft Office completely. If Online Repair fails, uninstall Office, restart your computer, and reinstall from your Microsoft account.

Frequently Asked Questions

Will I lose my data if I force-quit Excel?

Yes, any unsaved changes since your last save will be lost. However, Excel’s AutoRecover may have saved a recent version. When you reopen Excel, look for the Document Recovery pane on the left.

Why does Excel freeze only with one specific file?

That file is likely corrupted, or it contains a complex formula, macro, or external link that causes Excel to hang. Try the “Open and Repair” feature, or copy the data to a new workbook.

How do I know if an add-in is causing the problem?

Open Excel in Safe Mode (hold Ctrl while launching). If it works fine, an add-in is the culprit. Disable all add-ins, then re-enable them one by one to find the offender.

Is there a keyboard shortcut to recover an unsaved Excel file?

Yes. In Excel, go to File → Info → Manage Workbook → Recover Unsaved Workbooks. This shows temporary files saved by AutoRecover.

Can a large Excel file cause it to stop responding?

Absolutely. Files with millions of cells, complex array formulas, or many conditional formatting rules can exhaust memory. Try simplifying formulas, removing unused formatting, or using Power Pivot for large datasets.

What should I do if Excel freezes every time I start it?

Start in Safe Mode, disable add-ins, repair Office, and update. If the problem persists, check for conflicting software or a corrupted profile. In rare cases, a clean reinstall of Office is needed.

Related

• Strikethrough Shortcuts in Word: Fastest Ways
• Fix Delayed Notifications on Android: 7 Real Fixes
• How to Play Music Through Mic on Windows 10