If Excel’s repair process is not responding, first give it time to finish, especially if the workbook is large; repeatedly clicking or force-closing Excel can increase the risk of losing unsaved changes. If Excel is still usable, save a separate copy of the workbook, then use File > Open > Browse, select the file, click the arrow beside Open, and choose Open and Repair. If the whole Excel app is frozen, troubleshoot the app before trying the repair again.
What Excel repair does—and what a hang means
Open and Repair is a workbook-recovery option in Excel for Microsoft 365 on Windows. It attempts to open a workbook that Excel cannot open normally, often because the file is damaged. It is different from repairing Microsoft 365 itself: workbook repair addresses a particular file, while an Office app repair addresses problems with Excel’s installation.
A pause during repair does not by itself prove the process has failed. Large files, workbooks with many formulas or links, and files opened from a network location or cloud-synced folder can take longer to process. Excel may also appear frozen while it is working. Windows might label the window Not Responding when it is not processing the usual mouse or keyboard input; that label alone does not tell you whether the repair is making progress.
First identify what has stopped responding. If Excel’s window is frozen before you reach the Open and Repair command, the issue may be Excel, an add-in, or another startup component. If Excel is responsive but the repair dialog or progress appears stuck for one particular workbook, the problem is more likely associated with that file, its location, or its contents. The distinction helps you choose a safer next step.
What to do while Excel appears frozen
Avoid clicking the repair command repeatedly or launching several copies of Excel against the same file. Wait and observe whether the window returns, the progress changes, or the computer is still busy. For a large workbook, a longer wait may be reasonable; there is no universal time limit that proves a repair has failed.
- If Excel is still responsive, use Save As to make a separate working copy before trying another recovery method. Do not overwrite the only original.
- If the workbook is stored on a network drive, removable drive, or synced folder, check that the location is connected and accessible. If possible, copy the file to a local folder and work on that copy.
- Close unrelated apps if the computer is low on memory or resources, but do not close Excel while it is actively saving or repairing a file.
- If Windows continues to show Not Responding and the app has made no visible progress, note that ending the task can discard unsaved work. Use it only when waiting is no longer practical, and expect to recover from a saved copy, version history, or AutoRecover if available.
Task Manager can show whether Excel is still running and whether it appears to be using system resources, but it cannot confirm that a workbook repair will succeed. If you must end the task, open Excel again afterward and look for a Document Recovery pane or other recovered files before starting a new repair attempt.
Try Open and Repair on a copy
When Excel itself is responsive, use its built-in repair option on a duplicate. In Microsoft 365 for Windows, open Excel, select File > Open > Browse, and navigate to the workbook. Select the file once, click the arrow beside the Open button, and choose Open and Repair. If Excel offers Repair or Extract Data, try Repair first. If that does not work, Extract Data may recover some cell values or formulas, but it may not preserve the workbook’s full structure or formatting.
- Make a copy in File Explorer, or use Save As if the workbook is open and accessible. Give the copy a distinct name so it is easy to tell apart from the original.
- Start the Open and Repair process on that copy, not on the only file you have.
- If the repair succeeds, review important sheets, formulas, charts, links, and formatting. Save the recovered workbook under a new name.
- If it fails, close the copy without replacing the original and move on to another recovery source or diagnostic step.
Do not confuse a successful opening with a complete recovery. A workbook can open but still be missing some content or contain altered formulas, links, or formatting. Check the parts that matter to your work, and compare with a known-good copy if one exists.
Recover an earlier or unsaved version
Before trying increasingly aggressive repairs, look for another version of the workbook. If it is stored in OneDrive or SharePoint, check its version history and restore or download an earlier version to a different filename. Version history is especially useful if the file became damaged after a particular edit or sync event. Do not replace the current file until you have checked that the older version contains the data you need.
If Excel closed unexpectedly, reopen it and check whether the Document Recovery pane lists a recoverable version. In Excel for Windows, you can also look under File > Info for Manage Workbook and, when available, Recover Unsaved Workbooks. The options shown depend on whether Excel saved recovery information and on the workbook’s circumstances. AutoRecover is not a guaranteed backup, so its absence does not mean the file never existed.
For files saved locally, check any backup location or file-history system your organization uses. If the workbook came as an email attachment, download the attachment again rather than repeatedly repairing a possibly incomplete copy. For cloud files, confirm that synchronization has finished before opening or copying the file; a partially synced or unavailable file can look like a damaged workbook.
Check whether an add-in or Excel startup issue is involved
If Excel hangs with several workbooks, or hangs before you can reach repair, test whether it starts in Safe Mode. On Windows, press Windows key + R, enter excel /safe, and press Enter. Safe Mode starts Excel with certain startup features and customizations bypassed, making it a useful diagnostic comparison. It does not repair a workbook by itself.
If the workbook opens or Excel behaves normally in Safe Mode, an add-in or startup customization may be involved. In regular Excel, open File > Options > Add-ins. At the bottom, choose COM Add-ins in the Manage box and select Go. Clear a selected add-in to test without it, then restart Excel. Record which option you changed so you can restore it if it makes no difference. Add-ins can be managed differently in different categories, so check the relevant list rather than disabling unrelated software indiscriminately.
If Safe Mode also freezes on one file but other workbooks open, focus on recovering that file or finding another version. If Excel freezes across different files, update Office and investigate Excel or Windows issues before concluding that every workbook is damaged.
Repair the Microsoft 365 installation if Excel itself is the problem
When Excel is repeatedly unresponsive with multiple files, repairing the Office installation may help. On Windows 11, open Settings > Apps > Installed apps, find Microsoft 365, select the three-dot menu, and choose Modify. On Windows 10, look under Settings > Apps > Apps & features. Choose Quick Repair first if offered. If the problem remains, Online Repair is a more comprehensive option and may require an internet connection and sign-in or setup afterward.
This procedure repairs the Office installation; it is not a substitute for Open and Repair on a damaged workbook. Save work and close Office apps before beginning. If the computer is managed by an employer or school, the organization may control updates or repair permissions, so check with its IT support rather than changing managed settings.
On a Mac, the Windows Settings path and Windows Safe Mode command do not apply. Use the Mac version of Excel and its available update and recovery options; menus and repair tools differ by platform. If the Mac version cannot recover the workbook, try a copy in Excel for Windows when available, or restore an earlier cloud or backup version. Excel for the web can be useful for checking a copy, but it is not a replacement for Windows Open and Repair.
Common reasons repair fails or takes a long time
Repair can fail because the file is severely damaged, incomplete, or not actually an Excel workbook despite its filename extension. A workbook may also depend on external links, connections, macros, or features that complicate troubleshooting. Storage problems and permissions can interfere too: a file that cannot be read reliably from a network or synced location may behave differently when copied locally.
Try to narrow the cause without changing the original:
- See whether other workbooks open normally. If they do, the issue is more likely limited to this file.
- Check the file size and location against a known-good copy. An unexpectedly small file or a failed download can point to an incomplete copy, though size alone does not prove corruption.
- Try a local duplicate and, if possible, a previous version. This distinguishes some storage or sync issues from a problem in the workbook itself.
- Ask the file’s sender to resend it if it arrived by email or download, and confirm the file format and extension.
Changing an extension, renaming the file, or repeatedly resaving a damaged workbook is not a reliable repair method. Avoid third-party recovery utilities unless you have evaluated their privacy and security practices; a workbook may contain confidential business or personal data.
Protect the recovered workbook and your data
Once you have a workbook that opens, preserve the original and save the recovered file under a new name. Check key sheets and compare important totals with another source if one is available. Look for missing rows, broken formulas, unexpected blank areas, and errors in charts or linked data. If the workbook uses macros, confirm that the expected macro-enabled file type is retained when saving; a normal .xlsx file cannot store VBA macros.
Keep at least one separate backup while you verify the recovered copy. For important workbooks, use a routine backup or versioned storage rather than relying solely on AutoRecover or a single synced file. A repair attempt is a recovery measure, not a guarantee that every feature or piece of data can be restored exactly as it was.
Frequently Asked Questions
How long should Excel Open and Repair take?
There is no fixed duration. A large or complex workbook can take longer than a small file, and the computer or storage location can affect the process. Wait while Excel appears to be working, but if it remains unresponsive with no apparent progress, stop only after considering the risk to unsaved changes and try a separate copy or another recovery source.
Will ending Excel with Task Manager damage the workbook?
It can discard unsaved changes and interrupt a write in progress, so it is not the first choice. If Excel is irretrievably frozen, ending the task may be necessary, but preserve the original file and check for Document Recovery or an earlier version when Excel restarts. There is no guarantee that an interrupted repair can be resumed.
Does Office Quick Repair fix a corrupted Excel file?
Not directly. Quick Repair addresses the Microsoft 365 installation, which may help when Excel itself has problems across multiple workbooks. For one damaged workbook, use Open and Repair on a copy or recover an earlier version instead.
Can I repair a workbook in Excel for the web or on a Mac?
The steps and available recovery tools vary by platform. The Open and Repair instructions above are for Excel for Microsoft 365 on Windows. Excel for the web and Excel for Mac do not use the same Windows menus; try a copy, cloud version history, or a Windows copy of Excel if the workbook needs the Windows repair option.
Will Extract Data restore everything?
No. Extract Data is an alternative to a full workbook repair when Excel offers it, and it may recover values or formulas without restoring all workbook features. Treat the result as partial recovery: review it carefully and keep the original file and any other backups.
Related
- Excel Protect Sheet: How to Change a Password
- Excel Protect Sheet: How to Edit Protected Cells Easily
- Excel Protect Sheet but Allow Grouping: What Works
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Can You Fix a Corrupted Excel File? Safe Recovery StepsYes—Excel can often repair a corrupted workbook, but recovery is not guaranteed and some content may be lost.…
- VLOOKUP Not Working? Common Causes and FixesWhen VLOOKUP does not work, it is usually because the lookup value is not an exact match, the…
- Excel Not Working Correctly? Causes and Reliable FixesIf Excel is not working correctly, first save a copy of the workbook, note exactly what is failing,…
- Excel Power Query Formula Firewall Error: Causes and FixesThe Excel Power Query Formula.Firewall error usually means a query is combining data sources or referencing another query…
- VLOOKUP #N/A Error: Causes and FixesVLOOKUP returns #N/A when it cannot find the lookup value in the first column of the search range.…
- Excel Median Formula Not Working? How to Fix ItIf Excel’s median formula is not working, check that the range contains actual numbers and that the formula…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.