Excel Not Working Properly? Troubleshoot Common Issues

If Excel is not working properly, first save a copy of your workbook, close and reopen Excel, and check whether the problem affects one file or every file. If Excel itself freezes or crashes, start it in Safe Mode on Windows by pressing Windows+R, typing excel /safe, and pressing Enter; if the problem disappears, an add-in or startup setting may be responsible.

Start with the quickest checks

Before changing settings, note what Excel is doing: does it fail to open, stop responding, show an error, or display results that look wrong? The distinction matters. A damaged workbook calls for file-recovery steps, while a crash across several workbooks points more toward the Excel application, an add-in, or the computer.

Save your work if Excel still responds. If it does not, wait briefly before forcing it to close; a large calculation or data refresh can take time.
Close Excel and reopen it, then restart Windows if the issue continues. A restart can release resources or clear a temporary process problem.
Try a new blank workbook and, if possible, a second existing workbook. If only one file has the issue, focus on that file rather than resetting Excel.
Check that the workbook is stored somewhere you can access and edit. A network connection, cloud sync, or file permission can make a workbook seem broken when the app is functioning.

Do not repeatedly click buttons while Excel appears frozen. That can queue additional commands and make it harder to tell whether the application is recovering. If Windows reports that Excel is not responding, allow time for a demanding operation to finish before ending the task.

When Excel freezes, hangs, or crashes

Excel can slow down while recalculating a large workbook, refreshing external data, opening a file with many links, or processing complex formatting. A delay is not always a crash. Look for signs of activity, such as a changing status message or a progress indicator, and consider whether the workbook has grown substantially or recently gained formulas, data connections, or add-ins.

If Excel closes unexpectedly, reopen it and look for a Document Recovery pane. Open the most recent recovered version and save it under a new name before continuing. If the crash happens whenever you open one particular workbook, avoid overwriting the only copy: make a duplicate in File Explorer and troubleshoot the duplicate.

For a broader failure, use Safe Mode as an isolation test. In Safe Mode, Excel opens with certain features and startup items disabled. If it works normally there but fails during an ordinary launch, check add-ins and files that load automatically. Safe Mode is a diagnostic step, not a permanent repair, because it may disable features you rely on.

Check add-ins and startup files

Add-ins can extend Excel, but an outdated or incompatible one may cause slow starts, errors, or crashes. With Excel open normally, go to File > Options > Add-ins. At the bottom, use the Manage list to select COM Add-ins, choose Go, and clear the check box for an add-in to disable it. You can also select Excel Add-ins in the Manage list and choose Go to review that separate category.

Close and reopen Excel after disabling an add-in. If the issue stops, re-enable add-ins one at a time, restarting Excel between changes, until the problem returns. That can identify the likely cause. Check with the add-in provider for an updated version before deciding to leave it disabled; do not disable security or business tools without considering their purpose.

Excel may also load workbooks from startup folders. If Safe Mode works but disabling add-ins does not solve the problem, check whether a workbook or template that opens automatically is triggering it. Move suspected files to a temporary folder rather than deleting them, then test a normal launch. Excel’s startup-folder settings are under File > Options > Advanced, in the General section; the exact folder contents depend on the computer’s configuration.

Fix problems limited to one workbook

A file-specific problem can come from damage, excessive complexity, external links, or a feature that behaves differently across Excel versions. First make a copy. Then try opening the copy with File > Open > Browse. Select the file, use the arrow beside the Open button, and choose Open and Repair. If Excel offers repair or data extraction, read the prompt carefully: extracting data may preserve cell values while losing formulas or formatting.

If the workbook opens, test whether a particular sheet, chart, connection, or recently added feature is associated with the failure. You can also copy important sheets into a new workbook, but this may not bring along every workbook-level feature, such as certain connections, names, or macros. Compare the new file with the original before treating the copy as a complete replacement.

Files opened from email, a website, or another untrusted location may open in Protected View. This is a security feature, not automatically a sign that the workbook is damaged. Only choose Enable Editing if you trust the file’s source and expected its contents. If editing is blocked because of permissions or a read-only setting, check the file’s properties, sharing permissions, and whether someone else has locked it.

When formulas or displayed values look wrong

A workbook can appear broken even when Excel is operating normally. If a formula shows its text instead of a result, check whether the cell is formatted as Text, whether the formula begins with an equals sign, and whether Show Formulas is enabled. On Windows, Ctrl+` toggles Show Formulas; the key is usually the grave accent beside the number 1. On a Mac, the equivalent shortcut may depend on the keyboard layout, so use Formulas > Show Formulas if available.

If formulas are present but results do not update, check Formulas > Calculation Options and select Automatic. A workbook set to Manual calculation will not recalculate every formula after each change. Pressing F9 recalculates formulas in open workbooks, but changing the setting to Automatic is the more useful check when values repeatedly remain stale. Large models may take longer to recalculate, and automatic calculation can affect performance.

Also check for common causes of unexpected results: a number stored as text, a date interpreted under a different regional format, a formula referring to the wrong cells, or a filter hiding rows. An error such as #N/A or #VALUE! generally points to a formula or data issue, not a failed Excel installation. Inspect the formula bar, input values, and cell references before attempting a repair.

Update or repair Microsoft 365

Install available Office updates when Excel’s menus or behavior seem inconsistent, especially if the issue began after a recent change. In Windows desktop Excel, go to File > Account > Update Options > Update Now. Your organization may manage updates centrally, in which case the update controls can be unavailable or governed by IT policy.

If Excel continues to fail across multiple workbooks, repair Microsoft 365 from Windows settings. In Windows 11, open Settings > Apps > Installed apps, find Microsoft 365, choose the menu beside it, 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 extensive option and may require an internet connection and sign-in afterward.

Repair changes the Office installation, not the intended contents of your workbooks, but backing up important files first is still sensible. Menu names can vary slightly with the Windows build and Microsoft 365 installation type. If the repair option is missing, or the device is managed by an employer or school, ask its administrator before changing the installation.

Recover work and reduce the risk of losing it

If Excel closed before you saved, reopen the program and check Document Recovery. You can also look for unsaved work through File > Info > Manage Workbook, where available, and choose the option for recovering unsaved workbooks. Recovery depends on AutoRecover settings and on whether Excel had time to create a recovery copy, so it cannot guarantee that every recent change will return.

For future protection, use AutoSave when the workbook is stored in OneDrive or SharePoint and the feature is available, and save important work regularly with Ctrl+S on Windows. On Mac, use Command+S. Keep a separate backup for high-value files; synchronization is useful, but it is not always a substitute for a versioned backup. Before trying file repair, macros, or major structural changes, preserve an untouched copy.

Excel for Mac and Excel for the web

The main troubleshooting logic also applies on Mac: determine whether the problem affects one workbook or the app, update Office, test a blank workbook, and review add-ins. Windows-specific instructions such as Windows+R, the Windows Safe Mode command, and the Windows Apps repair path do not apply on Mac. Menu locations and available diagnostic options differ by platform, so use Excel’s Help menu or Microsoft Support for current Mac-specific steps rather than following Windows repair instructions literally.

Excel for the web is a useful comparison. Open a copy of the workbook in a browser, if your account and file location allow it. If the file works there but not in desktop Excel, the issue may involve the desktop installation, a desktop-only feature, or local settings. If the same problem appears in both, investigate the workbook, its data, or its permissions. The web version does not support every desktop capability, so a difference in behavior does not by itself prove that the desktop file is damaged.

Frequently Asked Questions

Why does Excel keep saying Not Responding?
It may be recalculating, refreshing data, or handling a large workbook, but repeated freezes can also involve add-ins, an outdated installation, or a problematic file. Test a blank workbook and Safe Mode to narrow down the cause.

Will repairing Microsoft 365 delete my Excel files?
Quick Repair and Online Repair are intended to repair Office, not erase workbook files. Still, save and back up important workbooks first, particularly if Excel is unstable or the files are stored in a location that is not syncing properly.

Why do my formulas show instead of their answers?
Check whether the cells use Text format, whether Show Formulas is turned on, and whether the entries begin with an equals sign. If results simply fail to refresh, check that calculation is set to Automatic.

Can I recover an Excel file I did not save?
Possibly. Reopen Excel and check Document Recovery, then look under File > Info > Manage Workbook for an unsaved-workbook recovery option. Recovery depends on AutoRecover and may not include the latest edits.

Why does Excel work in a browser but not on my computer?
The desktop app may have a local add-in, setting, or installation problem, or the workbook may use a feature that behaves differently in the web version. Compare a copy of the file and test desktop Excel in Safe Mode before concluding that the workbook is at fault.

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.