To open a damaged workbook in Excel for Microsoft 365 on Windows, first make a copy of the file, then go to File > Open > Browse, select the copy, click the arrow beside Open, and choose Open and Repair. Try Repair first; if it fails, repeat the process and choose Extract Data. Save any recovered workbook under a new name and check its contents before using it.
What You’ll Need
- A Windows computer with a desktop version of Excel installed. The Open and Repair command is a Windows desktop feature; Excel for the web does not provide the same repair command.
- The workbook file, such as an .xlsx, .xls, or .xlsm file, and permission to access its folder. If it is on a network or cloud drive, make a local copy if possible.
- Free storage space for a duplicate and a recovered version. Keep the original unchanged until you have checked the recovery.
- Access to a backup or version history, if one exists. This can be more useful than repairing a badly damaged file.
Step-by-Step
-
Protect the original file. Close Excel if the workbook is already open, then use File Explorer to copy the file into another folder or create a duplicate with a clear name such as Budget-repair-copy.xlsx. Do not use the damaged file as the only working copy, and do not rename its extension to try to fix it. If it is stored in OneDrive or SharePoint, check its version history before making changes; an earlier version may be intact. If the file is on a USB drive or network location, copy it to a local folder such as Documents first, so a dropped connection does not interrupt the process.
-
Start Excel and use its Open screen. Open Excel itself rather than double-clicking the damaged file. Choose File > Open > Browse. In the file picker, navigate to the duplicate you made. Starting from Excel gives you access to the repair option, which may not appear if you open the workbook from File Explorer. If you do not see Browse immediately, select Open and look for Browse in the list of locations.
-
Choose Open and Repair. Select the duplicate once, but do not open it with a regular double-click. Find the Open button at the bottom of the file picker, click the small arrow beside it, and select Open and Repair. Excel will ask how to proceed. If the Open and Repair choice is not available, check that you are using desktop Excel on Windows and that the file is selected in the Open dialog, not already open.
-
Try Repair first. In the prompt, choose Repair. Excel will attempt to recover the workbook structure and contents. Give it time, especially if the workbook is large or contains many sheets, charts, or links. Avoid repeatedly clicking buttons or closing Excel while it works. If the workbook opens, use Save As to write a separate recovered file, for example Budget-repaired.xlsx. Do not save over the original. If the source is an .xlsm macro-enabled workbook, preserve that format as .xlsm when saving if you need its macros; saving as .xlsx removes VBA macros.
-
Use Extract Data if Repair does not work. Start again with the untouched duplicate: File > Open > Browse, select the file, use the arrow beside Open, and choose Open and Repair. This time choose Extract Data. Excel may offer to recover values and formulas. This option aims to retrieve usable cell data when it cannot restore the workbook normally; it may not retain formatting, charts, objects, macros, or every formula. Save the result with a new name and treat it as a partial recovery, not a complete replacement.
-
Check the recovered workbook before relying on it. Compare the number and names of the sheets with what you expect. Check key totals, dates, formulas, hidden rows or columns, charts, named ranges, and any data tables you depend on. Look for blank areas, error values such as #REF!, and formulas that have been replaced by fixed values. If a workbook uses external links, macros, or queries, confirm those still work; a repair can leave some features unavailable even when the sheets open.
-
Keep the recovery and the source separate. Once you have checked the result, save a second working copy only if needed, and retain the original and the first recovery attempt until you are confident the content is complete. If your recovered file is important, make another backup in a separate location. This gives you a way back if later edits reveal missing data or broken features.
Common Mistakes
- Overwriting the only copy. A repair attempt can change or discard damaged content. Always work on a duplicate and save the output under a different name.
- Choosing Extract Data before trying Repair. Extraction can be useful, but it may recover less than a successful normal repair, particularly for formatting and workbook features. Try Repair first, then use extraction if needed.
- Changing the file extension. Renaming .xlsx to .xls or .xlsm does not convert the workbook and can make Excel less able to identify it. Use Save As to convert a file when it opens, and choose a format that matches the features you need.
- Assuming a successful open means everything is correct. A workbook may open while formulas, links, charts, or macros are missing or altered. Check important sheets and calculations before sharing it or making decisions from it.
- Ignoring a security warning to make the file open. If Excel shows Protected View or a warning about macros, do not enable editing or content unless you trust where the file came from. Repairing a file is not a reason to bypass security protections.
- Repairing a file while it is still being edited elsewhere. If another person or process is writing to the workbook, the copy may be incomplete or locked. Ask collaborators to close it and copy it again before starting recovery.
Tips
- Use version history before repair when available. For a workbook stored in OneDrive or SharePoint, check File > Info > Version History in desktop Excel, or use the file’s version-history option in the cloud service. Restore or download an earlier version as a separate copy rather than replacing the current file immediately.
- Keep the file in its original format during the first recovery. If Excel opens an .xlsm file, save the repaired copy as .xlsm if macros matter. For an older .xls workbook, retain a copy in that format before converting it. Excel may warn that some features are not supported when saving to another format.
- Make a note of what Excel reports. If a recovery dialog says that records were removed or repaired, note the message and inspect the affected features. The message may help you decide whether to restore an earlier version or rebuild a chart, formula, or connection manually.
- Prevent future losses with backups. Keep important workbooks in a backed-up location and save regularly. AutoRecover can help with unsaved work after a crash, but it is not a substitute for keeping a separate copy of a file.
- Use Excel for the web as a limited access option, not a repair tool. It may open a workbook that is difficult to open in the desktop app, depending on the damage and features in the file, but it does not offer the Windows Open and Repair command. If it opens, download or save a separate copy and inspect it carefully.
Troubleshooting
Open and Repair is missing. Confirm that you are using Excel desktop on Windows and that you reached the file through File > Open > Browse. The command is not available in Excel for the web, and Excel for Mac does not provide the same Windows repair workflow in all versions. On a Mac, preserve a copy, update Excel, try opening the copy in the desktop app, and check cloud version history or a backup. Do not assume that opening it in a browser repairs the underlying file.
Excel says the file format or extension is not valid. Check that you selected the intended file and that its size is not zero or unusually small. Confirm with the sender that the workbook was fully downloaded and that its extension matches the file type. Download it again or copy it from the original source, then retry Open and Repair on the fresh copy. Do not try random extensions; a renamed file is not a converted file.
Repair and Extract Data both fail. Try an earlier version from OneDrive, SharePoint, Windows File History, or another backup system if available. You can also ask the sender for a new copy. If the workbook is on a network drive, copy it locally and retry. When Excel reports that the file is blocked or access is denied, check folder permissions and Windows file properties rather than disabling security features. If no backup exists and the data is critical, stop experimenting on the source and consider a reputable data-recovery specialist.
Excel opens but then freezes or crashes. First test with a copy of the workbook and make sure no other Excel process is editing it. On Windows, you can start Excel in Safe Mode by pressing Windows key+R, entering excel /safe, and pressing Enter; this can help identify an add-in or startup issue, but it does not repair the workbook. If the file opens in Safe Mode, review Excel add-ins and update Office before retrying. Do not remove workbook content just to get past a crash without keeping a backup.
You need an unsaved version rather than a damaged saved file. In Excel for Windows, go to File > Info > Manage Workbook and look for Recover Unsaved Workbooks. The option and available files depend on AutoRecover settings and whether Excel saved a recovery copy. Open any candidate carefully and use Save As to keep it separately. For cloud files, check version history as well; an unsaved recovery copy and a cloud version are different sources.
Frequently Asked Questions
Can Excel repair a workbook automatically?
Excel may detect a problem and offer recovery when you open a workbook. For a deliberate attempt, use File > Open > Browse, then the arrow beside Open > Open and Repair. Recovery is not guaranteed, so keep the original and check the result.
What is the difference between Repair and Extract Data?
Repair attempts to restore a workbook so it can open normally. Extract Data aims to retrieve cell values and formulas when a normal repair is unsuccessful. Extraction can omit formatting and other workbook features, so inspect the output closely.
Will Open and Repair delete my original file?
The command is intended to open and recover the selected workbook, but you should not rely on it to protect your only copy. Make a duplicate first and save the recovered workbook under a new name.
Can I repair an Excel file on a Mac?
The Windows Open and Repair command described here is not available in the same way across Excel for Mac versions. Preserve a copy, check for a backup or cloud version history, install available updates, and try opening the copy in Excel for Mac or Excel for the web. Those alternatives may help access a file but do not guarantee repair.
Can I recover a workbook that Excel cannot open at all?
Try Open and Repair on a duplicate, then try Extract Data. If neither works, check version history, backups, or an unsaved-workbook recovery copy, and request a fresh copy from the sender. Avoid repeatedly changing the original file.
Will repairing preserve macros, charts, and formatting?
It may preserve some or all of them, but damaged workbooks can lose features during recovery, especially when using Extract Data. Keep macro-enabled files in .xlsm format when macros are needed, and verify charts, formatting, links, formulas, and macros in the saved copy before relying on them.
Related
- Google Sheets Insert Timestamp: Static or Live?
- Google Sheets Jira Add-On: Setup, Features, and Limits
- Google Sheets INDIRECT Conditional Formatting Explained
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Keep Track of Tasks at Work in ExcelTo keep track of tasks at work in Excel, create a table with one row per task and…
- How to Do Subscript in Excel With a ShortcutTo subscript text in Excel for Microsoft 365 on Windows, select the character or characters you want to…
- Excel Group Rows With a Header on Top in Microsoft 365To group rows in Excel while keeping a header visible, leave the header row outside the group: select…
- How to Close an Excel File With a Keyboard ShortcutIn Excel for Microsoft 365 on Windows, press Ctrl+W to close the active workbook. If you have unsaved…
- Excel File With Table Filters: How to Add and Use ThemYes—an Excel file can use table filters to show only the rows that match criteria, without deleting or…
- Translate Google Sheets to English: Formulas, Steps and TipsTo translate text in Google Sheets into English, enter a formula such as =GOOGLETRANSLATE(A2,"auto","en") in an empty cell,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.