Excel Not Working? Fixes for Common Problems

If Excel is not working, first save a copy of your workbook if you can, close and reopen Excel, and check whether the problem affects every workbook or just one. If Excel will not start, try opening it in Safe Mode; if only one file fails, troubleshoot that file rather than reinstalling Office immediately.

Start by identifying what is failing

“Excel is not working” can mean several different things: the app will not launch, it freezes, a workbook will not open, formulas show unexpected results, or a feature is unavailable. The right fix depends on which of these is happening. Note any error message and whether the problem began after an update, a new add-in, or a change to a particular file.

Use a simple comparison to narrow it down:

Open a blank workbook. If it works but one existing file does not, focus on that file.
Open a second existing workbook. If several files fail, the issue may involve Excel, an add-in, or Office installation.
Try the same workbook on another device or in Excel for the web, if available. This can help distinguish a damaged local installation from a problem with the file or its location.

Before troubleshooting a valuable workbook, make a copy in File Explorer or Finder if possible. Avoid repeatedly forcing Excel to close while it is calculating or saving; a long pause can be caused by a large calculation, external data refresh, or a file stored on a slow network location.

If Excel will not start or keeps crashing

On Windows, close any Excel process that is clearly stuck, then try starting Excel in Safe Mode. Press Windows key + R, type excel /safe, and press Enter. Safe Mode starts Excel without most add-ins and startup customizations. If Excel works there, an add-in or startup file is a likely cause, though Safe Mode alone does not identify which one.

To check add-ins in normal Excel, open File > Options > Add-ins. At the bottom, next to Manage, choose COM Add-ins and click Go. Clear the check boxes, restart Excel normally, and see whether the crash stops. If it does, turn add-ins back on one at a time, restarting after each, to identify the one associated with the problem. Excel add-ins can also be checked from the same Manage area by choosing Excel Add-ins. Only disable add-ins you recognize or that your organization allows you to change.

Also check whether Excel is waiting on a dialog box hidden behind another window. Use Alt+Tab to move through open windows. If the whole computer is unresponsive, Windows Task Manager can show whether Excel is still using CPU or memory; Ctrl+Shift+Esc opens Task Manager. Force-quitting can lose unsaved changes, so use it only when waiting is no longer practical.

On a Mac, quit and reopen Excel and check for updates through Help > Check for Updates if Microsoft AutoUpdate is installed. The Windows Safe Mode command and Windows add-in paths do not apply to Mac. If Excel crashes only when opening a particular file, test another workbook before changing broader app settings.

When one workbook will not open

If other workbooks open normally, the trouble may be limited to a damaged file, an unsupported feature, a permission issue, or a file that has not finished syncing. First make sure the file has fully downloaded from OneDrive, SharePoint, email, or a network drive. If it is on a shared drive, check that you have permission and that another person has not locked it for editing. A read-only message does not necessarily mean the workbook is damaged.

For a potentially damaged file on Windows, use Excel’s Open and Repair option. Choose File > Open > Browse, select the workbook, click the arrow beside the Open button, and choose Open and Repair. Try Repair first; if that fails, the Extract Data option may recover values and formulas, but it may not preserve formatting, charts, or other workbook features. Work on a copy and compare the recovered file with the original.

If the file is stored in OneDrive or SharePoint, check its version history before replacing or deleting anything. Earlier versions may be available from the file’s context menu in the web interface or through the service’s file details. For a workbook saved locally, look for another copy, an email attachment, or a backup. Excel cannot guarantee recovery of every damaged or unsaved file.

Fix formulas that look wrong

A workbook can open successfully while its results appear incorrect. If formulas are displayed as text instead of results, check whether the cells are formatted as Text or whether Show Formulas is enabled. On Windows, Ctrl+` toggles Show Formulas; on many keyboards the grave-accent key is beside the number 1. On Mac, the equivalent shortcut is Control+grave accent. You can also inspect the Formulas tab for Show Formulas.

If a formula does not recalculate, check the calculation setting at Formulas > Calculation Options. Automatic is the usual setting. If the workbook is set to Manual, Excel may leave results unchanged until calculation is requested; press F9 on Windows to recalculate open workbooks. Mac keyboards may require Fn+F9, depending on keyboard settings. A large workbook can take time to calculate, so check the status bar before assuming Excel has stopped.

Look at the exact error, too. #N/A commonly means a lookup did not find a match; #DIV/0! means a calculation attempted division by zero; and #NAME? can indicate misspelled function text or an unrecognized name. A formula using a newer function may not work in an older Excel edition. Microsoft 365 and Excel versions differ in supported functions, so confirm the recipient’s version before sharing a workbook that depends on recent features.

Improve a workbook that is slow or frozen

Performance problems can come from the workbook rather than Excel itself. Large ranges, volatile formulas, many conditional formatting rules, external links, data connections, and complex charts can all add work. A workbook that recalculates after every edit may also seem frozen, especially when it contains many formulas or a data model.

Start with low-risk checks:

Wait briefly and watch whether Excel is calculating, refreshing data, or saving before closing it.
Close other large workbooks and unnecessary programs to free memory.
Try a local copy if the file is on a network or cloud-synced folder; do not overwrite the shared original until you understand the sync status.
Check for unnecessary formatting or formulas applied to entire columns when only a small range is used.
Use Formulas > Calculation Options to test Manual calculation on a copy of a calculation-heavy workbook. Remember that results will not update automatically while Manual is selected; restore Automatic when appropriate.

Do not remove links, data connections, or formulas just to make a file smaller unless you know what depends on them. For a workbook used by colleagues, ask its owner or administrator before changing calculation settings or shared data sources.

Update Excel and repair Microsoft 365

On Windows, open File > Account and select Update Options > Update Now, if that option is available. Updates can address known reliability and compatibility issues. Your organization may manage updates centrally, in which case contact its IT support rather than changing managed settings.

If Excel still fails across multiple workbooks, repair the Office installation. In Windows 11, open Settings > Apps > Installed apps, find Microsoft 365, choose the three-dot menu, and select Modify. In Windows 10, use Settings > Apps > Apps & features, select Microsoft 365, and choose Modify. Run Quick Repair first. If the issue remains, Online Repair is a more thorough option and requires an internet connection; it can take longer and may require signing in again.

On Mac, Office repair is not offered through the same Windows Modify screen. Update Office with Microsoft AutoUpdate, restart the Mac, and if the problem continues, consult Microsoft Support for the current removal and reinstall steps for your macOS and Office version. Keep your account sign-in details and a backup of important files available before reinstalling.

Excel for the web and Mac-specific checks

Excel for the web can be a useful comparison when the desktop app has trouble. Open the workbook from OneDrive or SharePoint in a supported browser and see whether it loads. If it works online but not in desktop Excel, the local app, an add-in, or a desktop-only feature may be involved. If it fails in both places, consider file permissions, syncing, or workbook damage. The web version does not support every desktop feature, so a missing command alone does not prove the file is broken.

In a browser, refresh the page after confirming that edits have saved, and try a current supported browser or a private window if extensions might interfere. Do not close a tab during an upload or save indicator. On Mac, check available disk space, install Office updates, and restart the computer. Menu names and shortcuts differ between Mac and Windows, so do not assume a Windows troubleshooting path exists on Mac.

Protect your work while troubleshooting

Make a separate copy before attempting repairs, especially when a workbook contains important formulas, macros, or external connections. If Excel offers Document Recovery after a crash, review the recovered versions and save the one you need under a new name. AutoRecover is helpful but is not a substitute for saving regularly: its availability and recovery point depend on the settings and circumstances.

For future protection, save to a location with a reliable backup or version history, use descriptive filenames, and keep a separate copy of irreplaceable work. If Excel crashes repeatedly, note the version shown under File > Account, the Windows or macOS version, the workbook’s storage location, and the steps that trigger the failure. Those details make a support request more useful.

Frequently Asked Questions

Why is Excel not responding?
Excel may be calculating, refreshing data, saving a large file, or waiting for an add-in or dialog box. Give it time, check for a hidden prompt with Alt+Tab on Windows, and try Safe Mode if the problem repeatedly occurs at startup.

How do I recover an Excel file that was not saved?
In Windows Excel, check File > Info > Manage Workbook for recovered or unsaved workbooks. The exact options depend on the version and save settings. Also check Document Recovery after a crash and OneDrive or SharePoint version history if the file was stored there.

Why are my Excel formulas showing instead of answers?
Show Formulas may be switched on, or the cells may be formatted as Text. Toggle Show Formulas from the Formulas tab or Ctrl+` on Windows, then check the cell format and re-enter the formula if necessary.

Will repairing Office delete my Excel files?
Quick Repair and Online Repair target the Microsoft 365 installation, not ordinary workbook files, but a backup is still prudent before troubleshooting. Files stored only on a device, shared drive, or unsynced folder can have separate risks.

Why does Excel work online but not on my computer?
The desktop installation, an add-in, or a desktop-specific setting may be causing the issue. The web version can also behave differently and lacks some desktop features, so compare the exact workbook behavior rather than assuming the two versions are identical.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.