Excel Not Working? Fix Common Problems Step by Step

If Excel is not working, first identify whether it will not open, has frozen, is showing unexpected results, or cannot save; then restart Excel and your computer and use the matching fix below. If the workbook is still open, save a copy before troubleshooting so you do not risk losing recent changes.

Start by identifying the problem

Excel problems can look similar but have different causes. A workbook that opens slowly may be struggling with a large calculation or add-in, while a formula that appears unchanged may simply be waiting for recalculation. Note what happens, when it started, and whether the issue affects one workbook or every workbook. That distinction helps narrow down the cause.

Try these initial checks before changing settings:

Close and reopen Excel. If the entire computer is sluggish, restart the computer as well.
Try a new blank workbook. If it works normally, the problem may be specific to the original file.
Open a different existing workbook. If all files fail, suspect Excel, an add-in, or the Office installation rather than one damaged file.
Check whether Excel is waiting for a prompt hidden behind another window, such as a save confirmation or a message about an external link.
Write down any error message exactly. Its wording can point to a missing file, permissions issue, unsupported feature, or damaged workbook.

These checks are for Microsoft Excel for Microsoft 365 on Windows unless noted. Excel for Mac and Excel for the web have different menus and some troubleshooting options.

If Excel will not open

On Windows, first make sure Excel has not been left running in the background. Press Ctrl+Shift+Esc to open Task Manager, select a Microsoft Excel process if one is present, and choose End task. This closes that process, so any unsaved work in it may be lost. Then try opening Excel again from the Start menu.

If Excel still fails to start, test it in Safe Mode. Press Windows key+R, type excel /safe, and press Enter. Safe Mode starts Excel without most add-ins and custom startup files. If it opens this way, an add-in or startup item may be responsible. To investigate, go to File > Options > Add-ins. At the bottom, select COM Add-ins beside Manage, choose Go, and clear an add-in’s checkbox to disable it. Restart Excel normally and re-enable add-ins one at a time to find a conflict.

If Safe Mode does not help, install available Office updates: in Excel, go to File > Account > Update Options > Update Now. If Excel cannot open, use another Office app to reach the same account page, or use Windows Settings to repair Microsoft 365. On a Mac, check for updates through Help > Check for Updates, which opens Microsoft AutoUpdate. Safe Mode instructions and Windows repair menus do not apply to Mac.

If Excel freezes, runs slowly, or stops responding

A brief pause does not always mean Excel has crashed. Large workbooks may take time to recalculate, refresh data, load external links, or apply formatting to many cells. Wait a short time and check whether the status bar shows progress. Repeatedly clicking the window or ending the process can make it harder to tell whether work is still underway.

If the same file repeatedly freezes, try opening a copy and reducing the work it must do. Close other applications that are using substantial memory, remove unnecessary formatting from unused rows or columns, and avoid formulas or conditional formatting applied to entire columns when a smaller range will do. If the workbook uses external data, check whether a refresh is running or waiting for credentials.

For a startup slowdown, test Excel without add-ins using the Safe Mode method above. If that makes a difference, disable add-ins individually rather than removing all of them at once. On both Windows and Mac, also consider whether the issue began after installing an add-in, connecting to a new data source, or changing a workbook. Those clues can help distinguish an Excel-wide issue from a file-specific one.

When formulas show the wrong result

First check whether Excel is set to calculate automatically. In Excel for Windows, select Formulas > Calculation Options > Automatic. A workbook in manual calculation mode may keep displaying an earlier result until recalculation. Press F9 to recalculate open workbooks; on a Mac, use Fn+F9 on keyboards where the function keys have media controls, or choose the calculation command from the Formulas tab.

Next, inspect the cell itself. If you see the formula text instead of its result, the cell may be formatted as Text, or the formula may have been entered with a leading apostrophe. Change the cell format to General, then edit and re-enter the formula. Also check that Show Formulas has not been turned on; press Ctrl+` on Windows to toggle it, using the key usually located above Tab. On Mac, the shortcut can differ by keyboard layout, so use Formulas > Show Formulas if available on the ribbon.

Other common causes include a misspelled sheet name, an incorrect range, numbers stored as text, or a formula copied with an unintended relative reference. If a function name is not recognized, check that the Excel version supports it: some newer functions are limited to Microsoft 365 or recent perpetual releases. A file opened in an older version may not calculate newer functions as expected.

Problems opening one workbook

If other workbooks work but one file will not, make a copy of that file before attempting repair. Confirm that it has finished downloading or syncing, and that you have permission to open it. A cloud file may be unavailable because you are signed out, offline, or trying to open a link that has moved. Try opening the file from its current folder in Excel rather than from a stale recent-files entry.

For a workbook that may be damaged, use Excel for Windows: select File > Open > Browse, find the file, select the arrow beside the Open button, and choose Open and Repair. Choose Repair first. If that fails, the available extraction option may recover values and formulas while losing some formatting or features. Keep the original untouched and work on a duplicate.

File format also matters. A CSV stores plain tabular text, not multiple sheets, formulas, charts, or most formatting. If you save a workbook with those features as CSV, Excel may warn that some content cannot be retained. Choose an Excel workbook format such as .xlsx when you need to preserve typical workbook features; use a macro-enabled format such as .xlsm when the file must retain VBA macros.

If Excel will not save or sync

When saving fails, check the exact message and destination. A file may be read-only, open by another person, stored in a folder where you lack permission, or blocked by low disk space. Use File > Save As to save a separate copy to a folder you can access. If the original is on a network or cloud drive, saving locally can help establish whether the issue is Excel or the connection.

For OneDrive or SharePoint workbooks, confirm that you are signed into the correct account and that the service is online. Sync conflicts can occur when edits are made to separate copies or the connection drops. Do not assume that a visible workbook has synced successfully: check its saved or sync status, and verify the latest version from the cloud location before deleting or replacing any copy. If several people are editing, ask collaborators to pause while you resolve a conflict.

If recovery is needed after an unexpected closure, reopen Excel and look for the Document Recovery pane. You can also check File > Info for workbook management or version-related options, depending on where the file is stored and how it was saved. AutoRecover and cloud version history can help, but neither guarantees recovery of every unsaved change. Keep a separate backup for important work.

Repair Microsoft 365 and check compatibility

If Excel fails across multiple files and Safe Mode did not identify an add-in, repair the Office installation. In Windows, open Settings > Apps > Installed apps, find Microsoft 365, choose the three-dot menu, then Modify. Quick Repair is the faster first option; if the issue remains, Online Repair is more thorough and requires an internet connection. The wording may vary slightly across Windows releases. Close Office apps before starting and follow the prompts.

Check that the workbook was created in a compatible Excel version, especially if it uses macros, external connections, or newer functions. Protected View may also limit editing when a file came from the internet or an email attachment. If you trust the source, review the warning and use Enable Editing only when appropriate. Do not disable security protections globally just to open an unfamiliar workbook.

On a Mac, Office repair is not performed through the Windows Installed apps path. Update Office first, restart the Mac, and, if the problem persists, consult Microsoft’s current support instructions for reinstalling Microsoft 365 for Mac. Before reinstalling, confirm that files are saved or backed up and that you can sign in to your Microsoft account afterward.

How to reduce future Excel problems

A few habits reduce the risk of a small glitch becoming lost work:

Save regularly with Ctrl+S on Windows or Command+S on Mac, and use descriptive filenames for important versions.
Keep a separate backup of critical workbooks, especially before repairing a file, changing formats, or running macros.
Install Microsoft 365 updates and keep add-ins you rely on current.
Use .xlsx for ordinary workbooks and .xlsm only when macros need to be preserved.
Keep formulas, imported data, and formatting within the ranges actually needed rather than applying them to vast unused areas.

For a workbook that supports a business process, test changes on a copy and verify important outputs against a trusted source. A spreadsheet can open correctly yet still contain an incorrect formula, stale data, or a mistaken assumption; successful startup is not proof that its results are right.

Frequently Asked Questions

Why is Excel not responding? It may be calculating a large workbook, refreshing data, waiting for a hidden prompt, or encountering an add-in problem. Wait briefly, check for a prompt, then test the workbook in Excel Safe Mode on Windows. If only one file triggers the freeze, troubleshoot a copy of that file.

How do I restart Excel when it is frozen? Give Excel time to finish if it is showing progress. If it remains unresponsive, use Task Manager on Windows to end the Excel process, then reopen the app. On a Mac, use Force Quit from the Apple menu. Unsaved changes in a forcibly closed session may be lost.

Why are my Excel formulas not updating? Check Formulas > Calculation Options and select Automatic. Also verify that the cell is not formatted as Text, that Show Formulas is off, and that the formula references the intended cells. Recalculate after correcting the setting.

Can Excel recover an unsaved workbook? Sometimes. After reopening Excel, check the Document Recovery pane and the workbook management options under File > Info. Recovery depends on AutoRecover settings, save location, and whether a recoverable version was created, so it is not guaranteed.

Why does Excel work in a browser but not on my computer? The desktop app may have an add-in, update, installation, or local file issue, while the browser uses a different environment. Compare the same workbook carefully, and remember that Excel for the web does not support every desktop feature. Do not overwrite a desktop file with a browser copy until you have checked that needed features are preserved.

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.