Excel Not Working? Diagnose and Fix Common Problems

If Excel is not working, first check whether the problem affects one workbook or the entire app: save a copy if possible, close and reopen Excel, then try another workbook. If Excel will not start on Windows, press Win+R, enter excel /safe, and press Enter; if it works in Safe Mode, an add-in or startup customization may be interfering.

Identify What Is Actually Failing

“Excel not working” can describe several different problems: the app may fail to launch, freeze, crash, or open a file in read-only mode; a worksheet may show incorrect results; or one feature, such as saving or printing, may fail. Naming the symptom helps avoid risky fixes that do not address the cause.

Start with three comparisons. Does Excel work with a new blank workbook? Does the affected file work on another device or in Excel for the web? Does the issue occur only with a particular action, such as opening a large file or refreshing a connection? If a blank workbook works but one file does not, focus on that workbook, its contents, or its storage location. If every workbook fails, investigate Excel, Office, Windows, or an add-in.

Note the exact message, error code, or action that triggers the problem.
Check whether the file is stored locally, on a network drive, or in OneDrive or SharePoint.
Before trying repairs, make a separate copy of important files when you can access them.

A message that Excel is busy does not always mean it has crashed. A large calculation, data refresh, or complex workbook can take time. If the status bar or screen is changing, give it a chance to finish before force-closing the app.

When Excel Will Not Start or Keeps Crashing

On Windows, Safe Mode starts Excel without many add-ins and custom startup settings. Press Win+R, type excel /safe, and select OK. If Excel opens normally this way, an add-in or startup item is a reasonable suspect, but Safe Mode does not prove which one is responsible.

To investigate add-ins, open Excel normally if possible and select File > Options > Add-ins. At the bottom, use the Manage list to select COM Add-ins, then select Go. Clear a selected add-in and restart Excel. If you use Excel add-ins, inspect that category in the same Manage list as well. Disable items one at a time, testing after each change, so you can identify the one associated with the issue. Re-enable items that do not make a difference.

If Safe Mode also fails, restart Windows and install available Office updates. In Excel, the Windows update route is File > Account > Update Options > Update Now; the exact labels can vary with the Microsoft 365 installation. If Excel cannot open, use another Office app to check updates or move to an Office repair. Avoid deleting files from Excel’s startup folders unless you know what they contain; a template or add-in placed there may be something you rely on.

When One Workbook Will Not Open or Save

A file-specific problem can come from corruption, an incomplete download, a damaged network connection, permissions, or a format Excel does not fully support. First, save a copy under a different name and location if Excel permits it. If the original is on a shared drive or cloud service, try a local copy; if the local copy works, the issue may involve access or synchronization rather than the workbook itself.

If Excel reports that a file is damaged, use File > Open > Browse, select the file, choose the arrow beside the Open button, and select Open and Repair. The option may not appear for every file or in every version. Repair can recover some workbook content, but it is not a substitute for a backup and may not restore everything. Keep the original unchanged while checking the repaired copy.

Read-only status is not necessarily an Excel fault. The file may be locked by another person, marked read-only, opened from a location where you lack write permission, or protected by workbook settings. Check the title bar and any message at the top of the window. If a cloud file is involved, confirm that synchronization has completed and that you are signed in to the account with access. Do not remove protection or change sharing permissions unless you are authorized to do so.

When Formulas or Results Look Wrong

If a formula appears in the cell instead of its result, check whether the cell is formatted as Text or whether the formula begins with an apostrophe. Select the cell, change its number format to General, then edit and confirm the entry again. Also check whether Show Formulas is enabled: on Windows, Ctrl+` toggles that display in many keyboard layouts. The key is the grave accent, often found near the upper-left corner; keyboard layouts can differ.

If results do not update, check File > Options > Formulas and confirm that Workbook Calculation is set to Automatic, unless you deliberately need manual calculation. In manual mode, formulas can remain unchanged until recalculated. Pressing F9 recalculates open workbooks on Windows, but it is better to correct the calculation setting if automatic updates are expected.

Errors such as #NAME? or #VALUE! usually point to the formula, its references, or its input data rather than an Excel outage. Check spelling, quotation marks, ranges, and the type of values being supplied. Newer functions may also be unavailable in older Excel versions. For instance, XLOOKUP is available in Microsoft 365 and Excel 2021 or later, but a workbook using it may show an unsupported-function error in an older release. If a formula is correct but a linked value is stale, check whether the source workbook or external data connection is available and refresh only when you trust the source.

Fix Freezes, Slow Calculations, and High Resource Use

Large workbooks can be slow without being broken. Volatile formulas, extensive conditional formatting, whole-column calculations, external data connections, pivot tables, and many complex worksheets can increase recalculation or refresh time. If the delay began after adding data or formulas, test a copy of the workbook and narrow down the recent change rather than deleting content from the original.

When Excel stops responding, wait briefly if the workbook is calculating or refreshing. If the window remains frozen and there is no progress, Windows Task Manager can close the app: press Ctrl+Shift+Esc, select Microsoft Excel, and choose End task. Unsaved changes may be lost. On Mac, use Option+Command+Esc to open Force Quit; the Windows Task Manager shortcut does not apply.

After restarting, consider practical workload changes: close unrelated workbooks, reduce unnecessary formatting, avoid repeated calculations over more cells than needed, and refresh external data only when necessary. If the same file is slow on multiple devices, its design or size is more likely involved than a problem with one computer. If only one computer struggles with many workbooks, check available storage, memory pressure, Windows updates, and other applications competing for resources.

Repair Microsoft 365 Without Removing Your Workbooks

If Excel fails across different files and Safe Mode does not help, repair the Office installation. Close Office apps first. In Windows 11, open Settings > Apps > Installed apps, find Microsoft 365, select the three-dot menu, and choose Modify. On Windows 10, the route is generally Settings > Apps > Apps & features, followed by Microsoft 365 and Modify. Choose Quick Repair first; if the problem remains, try Online Repair. Available options and labels depend on the installation.

Repair is intended to fix Office program files, not to repair a damaged workbook. Still, keep workbook backups before troubleshooting, especially if the computer or storage device is unstable. Online Repair may take longer and requires an internet connection. If Microsoft 365 is managed by an employer or school, contact the administrator before changing the installation, since organization policies can restrict repair or updates.

On Mac, Windows Settings and the Windows repair steps do not apply. Update Excel through Help > Check for Updates, which opens Microsoft AutoUpdate in supported installations. If the problem continues, consult Microsoft support or the organization that manages the Mac rather than following Windows repair instructions.

Recover Unsaved Changes and Prevent Repeat Problems

After an unexpected close, reopen Excel and look for a Document Recovery pane. You can also check File > Info > Manage Workbook for available recovered or unsaved versions. The precise recovery choices depend on whether the workbook had been saved, AutoRecover was enabled, and Excel had a chance to write recovery data. Recovery is not guaranteed, so do not assume every recent edit can be restored.

To review AutoRecover on Windows, open File > Options > Save and check the AutoRecover settings. A shorter save interval can reduce the amount of work at risk, but it does not replace saving manually. AutoSave is different: it is designed for supported files saved to OneDrive or SharePoint, and it may not be available for a local file or every file type. For important work, use Ctrl+S regularly on Windows (Command+S on Mac), and keep a separate backup or use a managed version-history service when appropriate.

Before changing settings, updating software, or opening a questionable file, protect the workbook. Keep an untouched copy, particularly before using repair tools or changing links and data connections. If a problem returns, record the file type, Excel version, error text, and steps that reproduce it; those details make support requests much more useful.

Frequently Asked Questions

Why is Excel not responding?

Excel may be calculating, refreshing data, waiting on a network location, or dealing with a resource-heavy workbook. Wait briefly if there is evidence of activity. If it remains frozen, close it through Task Manager on Windows or Force Quit on Mac, recognizing that unsaved changes may be lost.

How do I open Excel in Safe Mode?

On Windows, press Win+R, enter excel /safe, and press Enter. Safe Mode helps determine whether an add-in or startup customization may be involved. This command is for Windows and does not work as a Mac launch instruction.

Why are my Excel formulas not calculating?

Check that calculation is set to Automatic under File > Options > Formulas, and confirm that the formula cell is not formatted as Text. Also verify the formula and its references. Manual calculation, a text-formatted cell, or an unsupported function can each make results appear wrong.

Can I recover an Excel file I did not save?

Possibly. Reopen Excel and check Document Recovery, or look under File > Info > Manage Workbook for recovered unsaved files. Recovery depends on AutoRecover settings and whether Excel saved a recovery copy; it cannot be promised.

Should I uninstall and reinstall Excel?

Usually, try updates, Safe Mode, and the Microsoft 365 repair options first. Reinstallation may be appropriate if repair fails, but check that you can sign in and reinstall your licensed version, and keep workbook backups. For a work or school device, ask its administrator before removing Office.

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.