Excel Not Working Correctly? Causes and Reliable Fixes

If Excel is not working correctly, first save a copy of the workbook, note exactly what is failing, and check whether the problem affects one file or every file. Then try the matching fix: recalculate formulas, disable add-ins, repair the workbook, or update and repair Microsoft 365. This step-by-step approach helps avoid changing settings or data unnecessarily.

Start by identifying what is actually failing

“Excel is broken” can describe very different symptoms: formulas show old results, a workbook will not open, the program freezes, or a feature behaves differently than expected. The cause is easier to find when you isolate the scope. Open a new blank workbook and try the same action that failed. If it works there, the original workbook, its data, or its settings are likely involved. If it fails in a new workbook too, investigate Excel itself, an add-in, or the installation.

Before troubleshooting, save the file under a new name or make a copy in File Explorer. If Excel is frozen, wait briefly before forcing it to close; a large calculation or save may still be underway. Ending the Excel task in Task Manager can discard unsaved changes, so use that only when the application has stopped responding and you accept that risk.

Record the exact error message and what you clicked immediately before it appeared.
Check whether the issue occurs in one workbook, several workbooks, or all workbooks.
Try the file on another device or in Excel for the web if available. This can help separate a local installation problem from a workbook problem.
Confirm that the workbook is not read-only, protected, or open by another person in a shared location.

Check calculation settings and formula results

If formulas are not updating, Excel may be set to manual calculation. In Excel for Microsoft 365 on Windows, open Formulas > Calculation Options and select Automatic. Manual mode can be useful for very large models, but it means a changed input may not immediately update dependent formulas. After changing the setting, press F9 to calculate. Ctrl+Alt+F9 forces a full calculation of formulas in open workbooks.

For a simple check, if A2 contains 12 and B2 contains 8, enter =A2+B2 in C2; the result should be 20. If the displayed result is the formula text instead, check whether the cell is formatted as Text or whether Show Formulas is enabled. On Windows, Ctrl+` toggles the display of formulas and results. If the cell was formatted as Text, change its number format to General, then edit and confirm the formula again; changing the format alone may not convert an existing text entry into a formula.

A formula error can also be a data issue rather than an Excel malfunction. For example, a number imported as text may not behave like a numeric value, and a reference to a deleted cell can produce an error. Inspect the formula bar, verify the referenced cells, and check for leading apostrophes or extra spaces. A formula that returns zero may be calculating correctly while pointing to blank cells or values that do not meet its criteria.

Determine whether the workbook is damaged or restricted

If only one file misbehaves, save a copy and test that copy. Look for unusual file extensions, links to external workbooks, macros, complex formatting, or recent changes. A file downloaded from the internet may open in Protected View, where editing is intentionally restricted. Enable editing only if you trust the source and expect the file to contain working content.

If a workbook will not open normally, use Excel’s recovery option. In Excel for Windows, choose File > Open > Browse, select the file, click the arrow beside the Open button, and choose Open and Repair. Try Repair first; if it does not work, reopen the menu and choose Extract Data where offered. Recovery may restore only some content, so compare any recovered file with a backup before relying on it.

Also check whether the file is stored in OneDrive, SharePoint, a network folder, or a removable drive. A temporary connection or synchronization problem can make a workbook appear unavailable or prevent saving. Copying a working copy to a local folder can help identify a location issue, but do not create competing copies if other people are editing the shared workbook. Agree on which copy is authoritative before replacing or resynchronizing files.

Test Excel in Safe Mode and check add-ins

An add-in can interfere with startup, editing, printing, or other operations. To test Excel for Windows in Safe Mode, close Excel, press Windows key+R, type excel /safe, and press Enter. If the problem disappears in Safe Mode, an add-in or a customized startup setting is a likely cause. Safe Mode is a diagnostic test, not a permanent fix; some features are intentionally unavailable there.

To review add-ins, open File > Options > Add-ins. At the bottom, use the Manage list to select COM Add-ins or Excel Add-ins, then click Go. Clear the check boxes to disable the relevant add-ins, restart Excel normally, and test again. Re-enable them one at a time to identify a specific conflict. If an add-in is required for work, contact its provider or your organization’s IT team before removing it permanently.

Excel for Mac has different menus and does not use the Windows excel /safe launch command. In Mac versions, review Excel > Settings (or Preferences in some releases) and the Add-ins controls available in that version. Menu names can vary by release, so use Excel Help if the control is not where expected. Excel for the web does not load desktop COM add-ins, which can make it a useful comparison for problems tied to those add-ins.

Resolve freezes, slow calculations, and crashes

Large workbooks can use substantial memory and processing time, especially when they contain many formulas, volatile calculations, external links, pivot tables, or high-resolution images. A freeze during a full calculation is not necessarily a crash. Give Excel time, particularly after changing a large data range or opening a workbook with extensive links. If the same task repeatedly stalls, test a copy with unnecessary sheets or objects removed rather than editing the only original.

Close other applications and unnecessary Excel workbooks to reduce resource pressure.
Check for formulas that refer to entire columns when a smaller, bounded range would be sufficient.
Review external links and queries that may be waiting on a network or data source.
Update Excel, then restart Windows so pending updates and background processes are not left in an uncertain state.
If a workbook is consistently slow, compare its behavior in a fresh copy and inspect recent additions such as formulas, conditional formatting, or imported data.

Do not repeatedly force-close Excel while it is saving. If Excel crashes, reopen it and look for a Document Recovery pane or a recovered version. AutoRecover can help restore some unsaved work, but it is not a substitute for saving regularly. Its availability and recovery interval depend on the application settings, and the most recent changes may not be recoverable.

Update or repair the Microsoft 365 installation

If the problem affects multiple workbooks and persists after the add-in test, install available Office updates. In many Microsoft 365 Windows installations, use File > Account > Update Options > Update Now. The exact controls can differ for work-managed devices, Microsoft Store installations, and organizational update policies. If Update Options is missing or unavailable, check with the administrator responsible for the device.

When updates do not resolve a broad problem, repair Microsoft 365 from Windows Settings. Open Apps > Installed apps, find Microsoft 365, choose its menu, and select Modify. Depending on the installation, Quick Repair checks common issues locally, while Online Repair is a more extensive repair that requires an internet connection and may take longer. Save work and close Office applications first. Labels and steps can vary slightly across Windows releases; a repair is aimed at the Office installation and is not a repair of a particular workbook.

On Mac, Office updates are generally managed through Microsoft AutoUpdate or the update controls provided with the installation. The Windows Settings repair procedure does not apply. If an organization manages updates, avoid trying to bypass its policies; report the version, error message, and steps that reproduce the problem to IT support.

Check file formats, compatibility, and expected behavior

Some apparent failures are differences between file formats or Excel versions. The .xlsx format stores most workbooks without VBA macros; .xlsm is used when a workbook needs to retain macros. Saving a macro-enabled workbook as .xlsx removes its VBA code, so keep the correct format when macros matter. Older .xls files can also have feature and worksheet limits compared with modern formats.

Features may not behave identically in desktop Excel, Excel for the web, and older perpetual versions. Microsoft 365 receives ongoing changes, while other editions may not include newer functions or capabilities. If a workbook uses a recent feature, check its requirements before assuming the file is corrupt. Some commands, data connections, macros, and add-ins are also limited or unavailable in Excel for the web. If a file opens differently across platforms, confirm the version, format, and feature involved.

Protect data while troubleshooting

Keep an untouched backup before repairing, converting, or removing workbook content. Be cautious with macros and external links in files from unknown sources: enable them only when you trust the publisher and understand why they are needed. If a workbook contains confidential data, avoid uploading it to an unfamiliar repair website or sharing it publicly to diagnose an error.

For business-critical workbooks, preserve the original error message, file version, and a reproducible sequence of steps. This information helps IT support distinguish a workbook defect from a network, account, permissions, or installation issue. If the file is shared, coordinate troubleshooting so that someone does not overwrite another person’s latest edits with an older copy.

Frequently Asked Questions

Why is Excel showing formulas instead of answers?
Show Formulas may be enabled, or the cells may be formatted as Text. On Windows, press Ctrl+` to toggle formula display. If the issue is confined to a cell, change its format to General and re-enter the formula.

Why are my Excel formulas not updating automatically?
Check Formulas > Calculation Options and select Automatic. If it is already automatic, press F9 and inspect whether the formula references the cells you expect. A workbook opened after another file set calculation to Manual may retain that setting for the Excel session.

How do I fix Excel when it keeps freezing?
Wait briefly in case it is calculating or saving, then test whether the issue occurs in a blank workbook or in Safe Mode. Close other applications, disable add-ins for diagnosis, and update Office. Avoid ending the task until you accept that unsaved changes could be lost.

Can I repair an Excel file that will not open?
On Windows, try File > Open > Browse, select the workbook, open the arrow beside Open, and choose Open and Repair. Work on a copy, because repair may not restore all content. Check backups or version history if repair fails.

Why does Excel work online but not on my computer?
That points toward a possible desktop-specific cause, such as an add-in, local installation, or device setting, but it does not prove which one is responsible. Test Excel in Safe Mode, check updates, and compare the exact workbook and actions across versions.

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.