Excel Not Working Right? Fix Common Problems

If Excel is not working right, first identify whether the trouble affects one workbook or the whole app, then try a restart, check calculation settings, and open Excel without add-ins. These checks solve many common problems without risking your data; make a copy of an important workbook before attempting repairs or more disruptive changes.

Start by identifying the problem

“Not working right” can mean a file will not open, formulas show unexpected results, Excel freezes, data appears missing, or a feature behaves differently than expected. The symptom matters: a problem limited to one workbook often points to that file, its formulas, or its connections, while problems across several workbooks are more likely to involve Excel, an add-in, an update, or the computer.

Before changing settings, note what happened and when. Record the exact error message, the workbook name, whether the file is stored locally or in OneDrive or SharePoint, and whether the issue began after an update or installing an add-in. If Excel displays a message, capture its full wording rather than relying on a paraphrase. This information helps distinguish a repeatable fault from a temporary interruption.

Try a different workbook, including a new blank workbook. If only one file is affected, focus on that file first.
Save your work, close Excel, and reopen it. If Excel is unresponsive, wait briefly before forcing it to close, since it may still be processing a large calculation or query.
Check whether the issue happens after a particular action, such as sorting, pasting, refreshing data, or opening a specific sheet.

Check whether the workbook or Excel is at fault

On Windows, start Excel in Safe Mode by pressing Windows key+R, entering excel /safe, and pressing Enter. Safe Mode starts Excel with certain customizations and add-ins bypassed. If the problem disappears there, an add-in or customization is a likely cause, though Safe Mode alone does not identify which one. Close Safe Mode and test the normal Excel app again after changing one item at a time.

If one workbook is the only one affected, make a separate copy before trying repairs. If it opens, use Save As to create a new copy in a trusted location. You can also try opening Excel first and then using File > Open > Browse to select the file. If the workbook is on a network drive or cloud service, check that the connection is available and, when permitted, try a local copy. A local copy can help determine whether sync or access is involved, but it should not become a competing version that other collaborators edit.

Excel’s Open dialog may offer an Open and Repair option for a workbook that will not open normally. In Windows desktop Excel, select File > Open > Browse, select the file, open the arrow beside the Open button, and choose Open and Repair. Choose Repair first; Extract Data is a fallback when repair cannot recover the workbook normally. This is not a guarantee, so preserve the original file and avoid overwriting it until you have checked the recovered copy.

Fix formulas that do not update or look wrong

When a formula result stays unchanged after its inputs change, check the calculation mode. In Windows desktop Excel, select Formulas > Calculation Options > Automatic. A workbook set to Manual calculation may not recalculate after edits. Pressing F9 recalculates open workbooks; Ctrl+Alt+F9 forces a full calculation of formulas. Laptop keyboards may require the Fn key for function keys. On Mac, menu names and keyboard behavior can differ, so use the Formulas menu and the keyboard shortcuts listed in Excel for Mac.

If a cell displays a formula as text instead of displaying its result, check whether the cell is formatted as Text or whether the entry begins with an apostrophe. Change the cell format to General, then edit the cell and press Enter. Merely changing the format may not convert a formula already stored as text. Also check for Show Formulas, which displays formulas in the worksheet rather than their calculated results; in Windows, use Formulas > Show Formulas to toggle that view.

A result that looks incorrect is not always an Excel fault. Check the formula’s cell references, number formats, date system assumptions, and whether cells contain numbers stored as text. For example, a percentage displayed as 250% may be numerically correct if the underlying value is 2.5, but it may not match the intended input. Look for error values such as #VALUE!, #REF!, or #N/A and trace the first formula that produces an error. If a formula uses a newer function, older Excel versions may not support it; Microsoft 365 and Excel 2021 support functions such as XLOOKUP, while feature availability can vary in other versions.

Deal with freezes, slow calculations, and crashes

Large workbooks can take time because of complex formulas, extensive formatting, external links, data connections, or volatile calculations. If Excel appears frozen during a refresh or calculation, check whether the status bar changes and give it time before ending the task. Repeatedly clicking or pressing keys can queue more work and make the delay harder to interpret.

To narrow down performance problems, test a copy of the workbook and temporarily disable background work only when you understand its effect. Consider whether the file contains whole-column references in many formulas, large numbers of conditional-formatting rules, or imported data that is no longer needed. Avoid deleting unfamiliar names, links, or queries from the original: other formulas, charts, or reports may depend on them.

If Excel crashes in normal mode but not Safe Mode, disable add-ins one at a time. On Windows, go to File > Options > Add-ins. At the bottom, select COM Add-ins beside Manage, choose Go, and clear an add-in’s checkbox. Restart Excel and test. You can re-enable the item if it makes no difference. Excel add-ins may appear under a different Manage selection, so check that list too. Do not remove an add-in simply because it is listed; first consider whether your workplace or workbook depends on it.

Check display, editing, and missing features

When a worksheet looks blank, check whether the relevant rows or columns are hidden, a filter is excluding records, or the active sheet is not the one expected. Zoom, freeze panes, and the selected print area can also make a worksheet look different without changing its data. Use the sheet tabs and row and column headings to investigate before deleting or rebuilding anything.

If a ribbon command is missing, the ribbon may be collapsed, the window may be narrow, or the current selection may not support that command. Some commands appear only when a table, chart, picture, or other object is selected. Excel for the web and Excel for Mac do not always show the same controls or menus as Excel for Windows. A feature may also require a particular Microsoft 365 subscription, update channel, or Excel version. Check the product version through File > Account in Windows desktop Excel before assuming a control has vanished.

For editing problems, check whether the worksheet or workbook is protected, whether the file opened in Protected View, and whether you have permission to modify it. Protected View is a security feature for files from potentially unsafe locations. Only select Enable Editing when you trust the file and its source. Do not disable Protected View globally to get past a single file warning.

Resolve problems opening, saving, or syncing files

A file that will not save may be read-only, open in another location, blocked by permissions, or affected by a full disk or a disconnected cloud service. Use File > Save As to create a copy in a location where you have write access. Check that the file name and folder are valid and that OneDrive or SharePoint has finished syncing before relying on a cloud copy. A sync icon or status message can reveal whether the latest edits have reached the shared location.

AutoSave is intended for supported files saved to OneDrive or SharePoint, but it is not a substitute for checking that edits have synchronized. If several people edit a workbook, confirm they are using the same shared file rather than separate downloads. Coauthoring and available behavior depend on the file location, format, and Excel version. For a workbook that contains macros, preserve the macro-enabled format when saving; changing formats can remove features or content that the new format does not support.

If a file opens with a warning, read it before proceeding. Links to external workbooks, data connections, and macros can have security implications or depend on resources that are unavailable. Do not enable content from an unknown sender just to make a workbook appear complete. Ask the file’s owner or your organization’s IT team to verify the source if the workbook is unexpected.

Update, repair, or reinstall Excel carefully

Installing available updates can fix known bugs and improve compatibility, but save and close your files first. In Windows desktop Excel, go to File > Account > Update Options > Update Now when that option is available. Work or school administrators may control updates, and menu options can vary by installation. On Mac, updates are generally managed through Microsoft AutoUpdate; check Excel > About Microsoft Excel or the Help menu for the update route shown by your installation.

If Excel continues to fail across multiple workbooks, consider repairing Microsoft 365 on Windows. Open Windows Settings > Apps > Installed apps, find Microsoft 365, select its options, and choose Modify if available. Quick Repair is the less extensive option; Online Repair is more thorough and may take longer or require internet access. The labels and route can vary by Windows release and installation type. Repairing Office is different from repairing a particular workbook, so keep backup copies of important files.

Reinstalling should be a later step, not the first response to a formula or file-specific issue. If this is a managed work computer, contact IT before changing the installation. Include the Excel version, Windows or Mac version, exact error text, and the tests already performed. That makes it easier to identify whether a policy, license, update, or device issue is involved.

When Excel for the web or Mac changes the steps

This guidance primarily describes Microsoft Excel for Microsoft 365 on Windows. Excel for the web runs in a browser and may not include every desktop feature, add-in, connection, or advanced editing control. If a workbook behaves differently there, open it in the desktop app if your account and file permissions allow, then compare the result. A browser refresh can help with a temporary web-session issue, but save or confirm synchronization before refreshing.

Excel for Mac has different settings paths and keyboard conventions: Command usually replaces Ctrl for common shortcuts such as saving, and some Windows-only repair and Safe Mode instructions do not apply. The precise options can also vary by update and license. Use the menus in the Mac app rather than assuming a Windows ribbon path exists. If a feature is unavailable on your platform, check Microsoft’s current support information or ask an administrator before moving a critical workflow to another tool.

Frequently Asked Questions

Why is Excel not responding? It may be calculating, refreshing data, opening a large file, or waiting on an add-in. Give it a short period to finish, then test Excel in Safe Mode on Windows. If the same workbook repeatedly causes the problem, troubleshoot a copy of that workbook before changing the app.

Why are my Excel formulas not calculating automatically? Check Formulas > Calculation Options > Automatic in Windows desktop Excel. A workbook can use Manual calculation, which delays updates. Also check whether the cells are formatted as Text or whether Show Formulas is enabled.

How do I fix Excel when it will not open a file? Confirm that the file is accessible and that you have permission to open it. Try File > Open > Browse and, if appropriate, Open and Repair. Keep the original unchanged and use a recovered or saved copy to verify that important sheets and data remain intact.

Can an Excel add-in make Excel crash? Yes. Add-ins can affect startup or particular operations. On Windows, start Excel with excel /safe; if the problem stops, disable add-ins one at a time through File > Options > Add-ins and restart to test. Check with IT before removing an add-in required for work.

Will repairing Office delete my Excel files? Office repair is intended to repair the application, not delete workbook files, but it is still sensible to back up important workbooks before troubleshooting. Keep copies in a separate, accessible location and confirm that cloud files have synchronized. If the issue concerns one damaged workbook, use a copy and workbook-recovery steps rather than treating Office repair as a file-recovery tool.

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.