Excel File Not Responding? Causes, Fixes, and Recovery

If Excel says Not Responding while you open a workbook, wait briefly first: a large file, recalculation, or a slow network connection can temporarily stall the app. If it remains stuck, try opening Excel in Safe Mode, then repair or recover the workbook using the steps below; avoid repeatedly force-closing it until you have considered whether work is still being saved.

What to do first when Excel stops responding

Look for signs that Excel is busy rather than frozen. The status bar may show Calculating, and Windows may display a spinning cursor while Excel processes data. A workbook with many formulas, external connections, charts, or large data tables can take time to open. Give it a few minutes if the file is unusually large or stored online, and avoid clicking repeatedly, which can queue additional actions.

If the app remains unresponsive, check whether another Excel window or a dialog box is waiting for input. Use Alt+Tab on Windows to cycle through open windows; an overlooked sign-in prompt, link-update message, or file-format warning can make the main window seem stuck. If Excel responds after you dismiss the prompt, save a copy of the workbook before making further changes.

Check whether the file is stored on a network drive, USB drive, or cloud service that may be slow or temporarily disconnected.
If possible, open another workbook. If other files work, the problem may be specific to the affected file.
If all Excel windows are unresponsive for several minutes, close Excel through Task Manager only as a last resort. Unsaved changes since the last save may be lost.

On Windows, Task Manager opens with Ctrl+Shift+Esc. Select Microsoft Excel and choose End task only when you have decided it is no longer making progress. On a Mac, use the Apple menu > Force Quit, or press Option+Command+Esc. The exact controls differ, but the same caution applies: force quitting can discard unsaved work.

Why an Excel workbook can hang while opening

Excel does more than display cells when it opens a file. It may calculate formulas, refresh data connections, load add-ins, check links to other workbooks, and render charts or conditional formatting. A workbook can therefore appear frozen even though Excel is still processing it. The delay may be temporary, especially after a major change or when opening a complex file for the first time.

Other causes include a damaged workbook, an Excel add-in that conflicts with the file, an outdated Office installation, insufficient available memory, or a file that is still syncing. A workbook can also depend on data sources that are unavailable. For example, formulas linked to a file on a disconnected shared drive may prompt Excel to search for that location.

File size alone does not tell the whole story. A smaller workbook with many volatile formulas, extensive formatting, or complicated pivot tables can be slower than a larger file containing mostly plain values. Likewise, a workbook that opens on one computer but not another may point to differences in add-ins, permissions, network access, or available resources rather than proving that the file itself is broken.

Recover unsaved work before troubleshooting further

If Excel closes unexpectedly, reopen it and look for the Document Recovery pane. It may list versions that Excel recovered after the interruption. Open the most recent candidate, compare it with what you remember, and use Save As to create a separate copy before continuing. Recovery files are not guaranteed, so a recovered version may be older than your last edits.

For a workbook that was never saved, Excel may offer an unsaved-file recovery option. In Microsoft 365 for Windows, check File > Info > Manage Workbook for recovery options, including Recover Unsaved Workbooks when available. The wording or availability can vary with the Office build and whether AutoRecover was enabled. If you find a candidate, save it under a new name rather than overwriting another copy.

AutoSave and AutoRecover are different. AutoSave can save ongoing changes for eligible files stored in OneDrive or SharePoint, when the feature is enabled. AutoRecover stores recovery information at intervals so Excel may restore work after a crash; it is not a replacement for saving. For important work, use Ctrl+S on Windows regularly, or Command+S on Mac, and keep version history or a separate backup where appropriate.

Open a damaged workbook with Excel’s repair option

If one workbook consistently hangs or fails while other files open normally, try Excel’s built-in Open and Repair feature. In Excel for Microsoft 365 on Windows, choose File > Open > Browse. Select the workbook in the file picker, click the arrow beside the Open button, and choose Open and Repair. If Excel offers a choice, try Repair first. If that does not work, Extract Data may retrieve values and formulas while leaving some workbook features behind.

Save any successfully opened or extracted content as a new file. Repair can remove damaged elements, and the result may not preserve every chart, formatting detail, macro, or connection. Keep the original unchanged so you can try another recovery route if needed. If the workbook is on a shared drive, first copy it to a local folder, provided you have permission, and attempt the repair on that copy.

Another useful test is to create a blank workbook and use File > Open to browse to the problem file, rather than opening it from a recent-files list or double-clicking it in File Explorer. This does not repair the file by itself, but it can help distinguish an opening shortcut or file association problem from a workbook-specific issue.

Check Excel add-ins and startup problems

An add-in can interfere with Excel during startup or when a workbook uses a particular feature. To test this on Windows, close Excel, press Windows key+R, enter excel /safe, and press Enter. Safe Mode starts Excel with certain customizations and add-ins disabled. If the file opens in Safe Mode but not in a normal session, an add-in or startup setting is a reasonable place to investigate; it does not prove which one is responsible.

To review COM add-ins in Excel for Microsoft 365 on Windows, go to File > Options > Add-ins. Beside Manage, select COM Add-ins and click Go. Clear a selected add-in to disable it temporarily, restart Excel normally, and test again. Change one item at a time so you can identify a likely cause, and re-enable items you need after testing. Excel add-ins are listed separately from COM add-ins, so check the relevant category if the suspect extension is not in the first list.

Safe Mode and these Windows startup instructions do not apply in the same way on Mac. Mac users can inspect available Excel add-ins from Tools > Excel Add-ins; options vary by add-in and Office version. If Excel itself will not start normally on either platform, installing available Office updates or following Microsoft’s Office repair guidance may be appropriate. Avoid deleting application files or registry entries based on generic online instructions.

Reduce delays caused by calculation and workbook complexity

If Excel eventually opens the workbook, check whether calculation is responsible for the delay. The status bar may indicate that formulas are calculating. A workbook with formulas that refer to whole columns, repeated lookups, or large ranges can require substantial processing. External links and data connections can also slow opening while Excel tries to retrieve information.

After making a backup, consider these checks:

Use Formulas > Calculation Options to see whether the workbook is set to Automatic or Manual. Manual calculation can reduce repeated recalculation, but formulas may remain out of date until you calculate them. Do not change this setting without understanding how the workbook is used.
Review Data > Queries & Connections for connections that refresh when the file opens. If a source is unavailable, confirm its location or ask the workbook owner before changing refresh settings.
Remove only unnecessary formatting or content, and check for formulas copied far beyond the active data. Large blank-looking ranges can still affect file size or performance.
Close other memory-intensive programs and make sure the computer has enough free disk space. Restarting can help when system resources are constrained, though it will not fix a damaged workbook.

Changing calculation to Manual is not a universal fix. It can make a workbook appear faster while hiding stale results, which is risky when users rely on current figures. If you use that setting as a diagnostic test, note the original setting and restore it when finished unless the workbook owner has a reason to keep it changed.

Separate workbook, Excel, and storage issues

Try opening a different workbook stored in a local folder. If it opens promptly, make a copy of the problem workbook locally and test that copy. A local copy that opens normally suggests the original location, permissions, synchronization, or network connection may be involved. A copy that still fails while other files work suggests the workbook itself or a feature it uses deserves closer attention.

For files in OneDrive or SharePoint, check that synchronization has finished and that you can access the file in the browser or through the service. Do not edit competing copies at the same time; doing so can create conflicting versions. If the file belongs to a workplace or school, an administrator may need to check access rights, network availability, or the organization’s data connections.

Excel for the web can be a useful comparison when a workbook is stored in OneDrive or SharePoint and the file type and features are supported. If it opens there but not in desktop Excel, the desktop installation, an add-in, or a desktop-specific feature may be involved. Excel for the web does not support every desktop feature, and a workbook that fails online is not automatically proven corrupt. Mac users can also test the same file in desktop Excel for Mac, but menus and add-in support differ from Windows.

Prevent future freezes and protect workbook changes

Keep Microsoft 365 and your operating system updated through their supported update channels, and use only add-ins you trust and need. Store working files in a location with reliable access, and avoid shutting down the computer while Excel is saving or syncing. For collaborative work, use the shared cloud copy rather than passing around multiple files with similar names.

For important workbooks, create versioned backups before major edits, structural changes, or repairs. A clear naming scheme, such as adding a date or version number, helps distinguish a recovery copy from the original. If a workbook has become unwieldy, ask its owner whether obsolete sheets, links, queries, or formatting can be removed; do not delete business data simply to make the file smaller.

Save regularly even when AutoSave appears active. Confirm that the saved file is in the intended location and that the sync indicator has completed before closing Excel. These habits cannot prevent every crash, but they make it less likely that a temporary hang will turn into lost work.

Frequently Asked Questions

Should I wait or force close Excel when it says Not Responding?
Wait a few minutes if the workbook is large, calculating, or opening from a slow location. Check for hidden prompts and signs of activity. Force close only when Excel has stopped making progress and you accept that unsaved changes may be lost.

How do I open Excel in Safe Mode?
On Windows, close Excel, press Windows key+R, type excel /safe, and press Enter. If the workbook opens in Safe Mode, test add-ins and startup settings. This command is for Windows; Mac does not use the same Safe Mode launch command.

Can I recover an Excel file I did not save?
Possibly. Reopen Excel and check the Document Recovery pane, or look under File > Info > Manage Workbook for Recover Unsaved Workbooks. Recovery depends on Excel having stored usable recovery data, so the latest edits may not be available.

Does Open and Repair always restore the whole workbook?
No. It may repair the file, or Excel may offer to extract data, but damaged formatting, charts, macros, or other features can be missing. Work on a copy and preserve the original.

Why does only one Excel file stop responding?
That workbook may be unusually complex, damaged, dependent on an unavailable connection, or affected by a feature or add-in. Compare it with another workbook, test a local copy, and use Open and Repair if the problem follows that file.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.