Excel Not Working? How to Diagnose and Fix Common Issues

If Excel is not working, first save a copy of your workbook if possible, close and reopen Excel, and restart your computer. Then identify whether the problem affects Excel itself, one workbook, or a particular formula; use the matching checks below, and avoid disabling security features or overwriting the only copy of an important file.

Identify what is actually failing

Excel problems can look similar but have different causes. A program that will not open points toward startup, add-in, update, or installation trouble. A program that opens but freezes only with one large workbook may be struggling with that file’s calculations, links, formatting, or data. If a workbook opens normally but displays an unexpected answer, investigate the formula and cell values before repairing Office.

Write down what happens and when: the exact error message, whether Excel closes or stops responding, which workbook is affected, and whether the problem began after an update or a change to an add-in. Try a new blank workbook. If the blank workbook works, the original file or something it contains is a stronger suspect. If all workbooks fail, focus on Excel, the operating system, or the installation.

Excel will not launch: try a restart and, on Windows, a Safe Mode launch.
Only one file fails: work on a copy and try Excel’s Open and Repair option.
Formulas show wrong results: check calculation settings, references, and cell formats.
Excel is slow or freezes: check workbook size, add-ins, and available system resources.

Try safe checks before changing settings

Start with actions that do not alter workbook contents. Close other demanding applications, confirm that the computer has available storage, and restart it. If Excel is responding, save the file under a new name before testing changes. If it is not responding, wait briefly when a large calculation is running; forcing it to close can lose unsaved edits.

Check whether the problem is limited to one device or account. For a file stored in OneDrive or SharePoint, try opening it from Excel’s recent files or the storage service in a browser, and check whether another authorized user can open it. If Excel for the web works while the desktop app does not, the file may be sound and the desktop installation or its settings may need attention. If several Microsoft 365 services fail, check Microsoft’s service status information or ask your organization’s administrator.

Do not repeatedly rename a damaged file, delete temporary files at random, or download a replacement workbook from an untrusted site. If the document contains important information, preserve the original and test only on a duplicate. A copy also makes it easier to tell whether a repair step actually helped.

Excel will not open or keeps crashing

On Windows, test whether an add-in is causing a startup problem. Press Windows key+R, enter excel /safe, and press Enter. Safe Mode starts Excel with certain features and add-ins bypassed. If Excel opens this way, an add-in or customization may be involved; Safe Mode is a diagnostic test, not a permanent fix.

To check COM add-ins in normal Excel, choose File > Options > Add-ins. At the bottom, set Manage to COM Add-ins and select Go. Clear the check box for an add-in, restart Excel, and see whether the issue disappears. Re-enable add-ins one at a time to find the cause. Excel add-ins can also be reviewed by choosing Excel Add-ins in the Manage list. The names and available add-ins vary by installation, so disable only items you recognize or can verify with your administrator.

If Excel still fails, install available updates and use the Microsoft 365 repair options described below. On a Mac, Windows Safe Mode and the Windows COM Add-ins dialog do not apply. Quit Excel, restart the Mac, install available Microsoft 365 updates, and investigate Excel add-ins from Excel’s Tools > Excel Add-ins menu. If the problem persists across workbooks, contact your organization’s support team before removing managed software or profiles.

Fix formulas that do not calculate correctly

First check whether Excel is set to calculate automatically. In Excel for Microsoft 365 on Windows, go to Formulas > Calculation Options and select Automatic. Manual calculation can leave displayed results unchanged after inputs change. You can recalculate the open workbook with Formulas > Calculate Now. Calculation settings and commands can differ somewhat across Mac and web versions, so look for the Calculation controls on the Formulas tab or in Excel settings.

For example, with sales values of 120, 85, and 95 in cells B2:B4, this formula totals the range:

=SUM(B2:B4)

The result is 300 because 120 + 85 + 95 = 300. If the formula appears as text instead of returning a number, select the cell, change its number format to General, and re-enter the formula. Check for a leading apostrophe or a space before the equals sign as well. If a result seems wrong, make sure the formula points to the intended cells and that the cells contain numbers rather than number-like text.

Read the error displayed in the cell rather than treating every formula issue as an Excel failure. #DIV/0! usually means a formula divides by zero or an empty cell; #NAME? can indicate an unrecognized function name or text that is not enclosed as text; and #REF! signals an invalid cell reference, often after referenced cells were deleted. A green error indicator may also flag a possible issue without proving the formula is wrong. Check the formula bar and trace the inputs before replacing a formula.

Regional settings can affect how formulas are entered. Some installations use semicolons instead of commas to separate function arguments, depending on regional list-separator settings. If a formula copied from another computer is rejected, check the separator your Excel expects and confirm that the function is available in your version. Excel for Microsoft 365 and Excel 2021 include newer functions such as XLOOKUP, while older releases may not.

Recover a workbook that will not open

Make a duplicate of the file first, especially if it is stored on a network drive or cloud service. In desktop Excel for Windows, select File > Open > Browse. In the Open dialog, select the workbook, open the arrow beside the Open button, and choose Open and Repair. If Excel offers a repair option, follow its prompts; if repair is not available or does not work, try the option to extract data when offered. The exact choices depend on the file and Excel version.

For a cloud-stored workbook, check version history before attempting extensive recovery. OneDrive and SharePoint provide version-history features when the file is stored there and the account has access. Restoring an earlier version can discard later edits, so review the version date and, when possible, save a separate copy instead of replacing the current file. For a local workbook, check File > Info for available workbook recovery information, and look for a backup if your organization or backup software creates one.

If the file opens but displays a Protected View banner, that is a security precaution for files Excel considers potentially unsafe. Enable editing only when you trust the file and its source. Do not turn off Protected View globally just to open one attachment. If a file arrives unexpectedly, verify it with the sender through a separate channel before enabling content or following instructions inside it.

Make a slow workbook more responsive

A workbook can become slow because it contains many formulas, large data ranges, external links, complex conditional formatting, or calculations that must be repeated often. A slow workbook is not automatically corrupt. Test a copy, then identify whether the delay happens while opening, editing a cell, filtering data, or recalculating; that pattern can narrow down the cause.

Close other workbooks and applications to reduce competition for memory and processing time.
Check whether formulas refer to entire columns or unnecessarily large ranges, especially in repeated calculations.
Review external links and data connections, and confirm whether they are still needed before removing them.
Save a test copy in the current Excel workbook format, such as .xlsx, if the file is in an older format; keep the original because conversion can affect features.
Use smaller test copies to isolate a slow worksheet or feature, but do not delete source data from the only copy.

Large datasets may be better handled with Excel tables, filters, or Power Query rather than a long chain of manual edits. Those tools do not guarantee that every workbook will run faster; the right approach depends on the data and the calculations. If the workbook is shared, coordinate changes because removing links, changing formulas, or converting formats can affect other users.

Update or repair Microsoft 365

On Windows, open Excel and choose File > Account > Update Options > Update Now. The Update Options menu may be managed or unavailable on a work or school device; in that case, follow your organization’s update process. On a Mac, use Help > Check for Updates to open Microsoft AutoUpdate when it is installed and enabled. Updating can fix known problems, but it may not resolve a corrupt workbook or an incompatible add-in by itself.

If the Windows desktop app continues to malfunction across different files, close Office applications and open Windows Settings > Apps > Installed apps. Find Microsoft 365 or Office, select its menu, and choose Modify. Run Quick Repair first; if that does not help, consider Online Repair, which may take longer and require an internet connection. The labels can vary with the Office installation. Save your work and make sure you can sign in again before repair, especially on a managed device.

Repairing Office is not the same as repairing a particular workbook. If only one file has trouble, prioritize a safe copy and workbook recovery. If every workbook has trouble, updating or repairing the application is more relevant. Avoid uninstalling Office as an early step: it can take longer, may require administrator access, and does not fix a damaged file.

Excel for the web, Mac, and Windows differences

Excel for the web runs in a browser and does not expose every desktop feature. If the web version cannot edit a file, confirm that you are signed into the account with permission and that the workbook is not open in a conflicting state. Try refreshing the page only after checking that edits have saved. A private browsing window can help identify a browser extension or cached sign-in issue, but it will not repair a damaged workbook or change account permissions.

On Mac, Windows paths such as File > Options, Windows Settings, and excel /safe are not applicable. Use the Mac version’s Excel settings and Help > Check for Updates, and check with an administrator if the device is managed. Menus and features may vary by operating-system version and Microsoft 365 update channel. When following online instructions, verify that the directions match desktop Excel on your operating system rather than Excel for the web.

Prevent the same problem from returning

Keep Excel and the operating system updated through approved channels, and install add-ins only from sources you trust. Save important workbooks in a location with version history or a separate backup, and use descriptive file names when testing repairs. For shared workbooks, avoid making simultaneous structural changes without coordinating with collaborators.

Before changing a file format, removing links, or running a repair, consider which features the workbook uses: macros, external connections, specialized formatting, or collaboration features may behave differently after changes. Keep the untouched original until the repaired copy has been checked. If a business-critical workbook repeatedly fails, record the error and the steps that reproduce it; that information helps an IT administrator or workbook owner investigate without guessing.

Frequently Asked Questions

Why is Excel not responding?
Excel may be calculating a large workbook, waiting on an external connection, or affected by an add-in or limited system resources. Give a calculation time to finish, then test a blank workbook and, on Windows, try excel /safe to check whether an add-in is involved.

How do I fix Excel when it will not open?
Restart the computer, try Windows Safe Mode with excel /safe, and install available updates. If Excel opens in Safe Mode, investigate add-ins. If the issue continues across files, use the Microsoft 365 repair option on Windows or ask your administrator for help.

Why is my Excel formula showing instead of the answer?
The cell may be formatted as Text, or the entry may begin with an apostrophe or extra space. Set the cell to General and re-enter the formula. Also check whether Show Formulas is enabled or whether calculation is set to Manual.

Can Excel repair a corrupted file?
Excel for Windows includes Open and Repair for some workbooks, but repair is not guaranteed. Work on a copy, try File > Open > Browse and the arrow beside Open, and check cloud version history or backups if the repair does not recover the file.

Why does Excel work online but not on my computer?
The workbook may be accessible while the desktop app has an add-in, update, or installation problem. If the same file works in Excel for the web, test desktop Excel with a blank workbook and troubleshoot its add-ins or installation separately.

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.