“Excel repair now error” is not one specific Microsoft Excel error code; it usually describes a prompt or failure while Excel tries to repair a damaged workbook, or a request to repair Microsoft 365 itself. First, make a copy of the affected file, then try Excel’s built-in Open and Repair command; if Excel itself will not start or keeps crashing, troubleshoot Office separately.
What the Excel repair message means
Excel checks a workbook’s internal structure when it opens it. An .xlsx or .xlsm file is a package of related parts, including worksheets, formatting, formulas, and other workbook information. If Excel detects that some content is damaged or inconsistent, it may offer to repair the file, open it with recovered content, or extract data. Depending on the problem and Excel version, the message may report that it found unreadable content or list records it removed.
A repair can make a workbook usable without restoring every feature exactly as it was. For example, Excel might recover the cell values but remove a damaged chart, formatting rule, or other workbook object. A message saying that Excel repaired a file is therefore not proof that every original element survived. Review the opened workbook and, when Excel offers a repair log, check it for details about removed or recovered content.
The wording matters. A prompt about repairing a particular file points toward workbook damage. A Windows notification or Microsoft 365 setup screen offering a Quick Repair or Online Repair concerns the Office installation. These are different problems with different remedies; repairing Office will not necessarily fix a damaged workbook.
First identify whether the workbook or Excel is failing
Notice when the message appears. If Excel starts normally and only one workbook triggers the warning, focus on that file. If several unrelated workbooks fail, Excel crashes before a file opens, or other Office apps also behave strangely, investigate the installation, updates, add-ins, or Windows environment as well.
Try opening a known-good workbook, or create a blank workbook from Excel’s start screen. If those work, the original file is a stronger suspect. If Excel hangs or closes even with a blank workbook, the issue is less likely to be limited to one file. Also note where the file is stored: a network share, email attachment, removable drive, or cloud-synced folder can introduce transfer or synchronization problems that look like file damage.
Do not repeatedly overwrite the only copy while testing. A repair may change workbook contents, and a failed save can make recovery harder. Preserve the original and test a duplicate in a local folder such as Documents.
Protect the file before trying a repair
Make a copy before any repair attempt. In File Explorer, copy the workbook and give the copy a clear name, such as Sales-copy-before-repair.xlsx. If the file is on OneDrive or SharePoint, consider checking version history before changing it; an earlier saved version may be easier to recover than a partially repaired copy.
Check that the file has finished downloading or syncing. If it arrived by email, save it to your computer rather than opening it directly from the mail preview. Confirm that the drive has free space and that you have permission to edit the file. If Excel opens the workbook in Protected View, use care: do not enable editing or macros merely to get past a repair warning unless you trust the file’s source.
If the workbook contains macros, preserve the original .xlsm extension. Saving a macro-enabled workbook as .xlsx removes VBA code. Likewise, avoid changing file extensions by renaming the file; changing .xls to .xlsx does not convert its contents and can make diagnosis more confusing.
Use Open and Repair in Excel for Windows
For Microsoft 365 Excel on Windows, use the built-in repair option on a copy of the workbook:
- Open Excel, then select File > Open > Browse.
- In the file picker, select the workbook once. Do not open it with a double-click.
- Select the arrow beside the Open button, then choose Open and Repair.
- Choose Repair first. If Excel cannot repair the file, repeat the process and choose Extract Data, if that option is available.
- Save any successfully opened result under a new name, then inspect sheets, formulas, charts, links, and macros before treating it as complete.
Repair attempts to preserve as much of the workbook as possible. Extract Data is a fallback for retrieving values and formulas when a full repair does not work; it is not a promise to restore the original layout or every workbook feature. If Excel displays a log or a list of removed items, keep a copy of that information while you compare the recovered file with the original.
If you do not see Open and Repair, make sure you are selecting the file from Excel’s Open screen and using the arrow beside Open. The command is not the same as opening the file from File Explorer. Menu labels can vary slightly between Office builds, but the option is part of Excel for Windows desktop, not a general Windows file-repair command.
If Excel itself will not open or keeps failing
When the problem affects Excel broadly, start with simple checks: restart Windows, install available Office updates, and test a blank workbook. An add-in can also interfere with startup or opening. To test that possibility, close Excel, press Windows key + R, type excel /safe, and press Enter. Safe Mode starts Excel with certain customizations and add-ins bypassed. If Excel behaves normally there, review enabled add-ins through File > Options > Add-ins. At the bottom, select COM Add-ins beside Manage, choose Go, and disable add-ins one at a time to identify a possible cause.
On Windows, Office installation repair is a separate step. Close Office apps, then open Settings > Apps > Installed apps, find Microsoft 365, select its menu, and choose Modify. Depending on the installation, select Quick Repair first. If the issue continues, use Online Repair, which requires an internet connection and may take longer. The exact Settings labels can differ slightly by Windows release. Save work and close documents first.
These installation repairs can address damaged Office program files, but they are not substitutes for making a workbook backup. On a Mac, Windows’ Modify and Quick Repair controls do not apply. Update Excel through the channel used to install it, such as Microsoft AutoUpdate or the Mac App Store, and consult Microsoft’s Mac support steps if an Office reinstall is needed. Excel for the web also does not provide the Windows desktop Open and Repair command.
Recovery options if Open and Repair fails
Try another copy or source before concluding that the data is lost. If the workbook was stored in OneDrive or SharePoint, use its version history to restore or download an earlier version; the interface and available history depend on the service and account. For a file on a Windows PC, File History or another backup may have a previous copy, but only if backup was configured before the problem.
If Excel previously had the workbook open, look for an AutoRecover or unsaved-workbook copy. In Excel for Microsoft 365 on Windows, check File > Info > Manage Workbook > Recover Unsaved Workbooks when that option is available. AutoRecover can help after an unexpected closure, but it is not a complete backup and may not contain the latest edits. Excel’s AutoSave feature is also different: it saves changes automatically for supported files stored in OneDrive or SharePoint when enabled, rather than repairing damaged content.
For important workbooks, especially ones containing business-critical records, stop experimenting if the remaining copy is the only one. Keep it unchanged and ask the file owner or IT administrator about backups and recovery options. A specialist may be able to assess a damaged file, but avoid uploading confidential data to an unknown repair website. Check the provider’s privacy and security terms before sharing a workbook externally.
Common causes and ways to prevent repeat problems
Workbook corruption can follow an interrupted save, a computer shutdown, a sync conflict, a failing storage device, or an incomplete transfer. It can also involve a particular workbook component rather than every worksheet. A sudden power loss while Excel is writing a large file, for instance, may leave the saved package incomplete. A damaged file is not necessarily evidence that the workbook’s formulas were wrong or that Excel intentionally deleted data.
Reduce the chance of losing work by keeping more than one reliable copy and allowing saves or cloud synchronization to finish before shutting down or disconnecting a drive. Use a stable network connection for files stored on shared locations, and avoid editing the same file simultaneously in multiple places unless the storage service supports that workflow. Keep Windows and Office reasonably current, and remove add-ins you no longer use.
For large or important workbooks, periodically save a dated copy or use the version history provided by your storage service. Check that backups can actually be opened. This is especially useful for macro-enabled files and workbooks with external links, custom formatting, or charts: a recovered file may retain the main data while losing one of those dependent features.
Frequently Asked Questions
Is Excel Repair Now a virus or a specific error code?
Not by itself. “Excel repair now error” is a search phrase, not the name of one standardized Excel error code. A repair message can refer to a workbook, while a Microsoft 365 repair option refers to the Office installation. Read the full message and note when it appears.
Will Open and Repair delete my original workbook?
It is safest to run it on a duplicate and save the recovered result under a new name. That preserves the original for comparison or another recovery attempt. A repaired copy may still be missing damaged workbook elements.
What should I choose: Repair or Extract Data?
Choose Repair first when Excel offers both options, because it aims to recover the workbook structure and content. Use Extract Data if Repair fails and your priority is retrieving available values or formulas. Inspect the result rather than assuming it is a complete restoration.
Can I repair an Excel file online or on a Mac?
Excel for the web does not include the Windows desktop Open and Repair command. On a Mac, use available version history or backups and follow Microsoft’s current Mac support guidance for Office problems. Avoid uploading sensitive files to third-party tools unless you trust their handling of your data.
Does reinstalling Microsoft 365 repair a corrupt workbook?
Usually, reinstalling or repairing Office addresses Excel program problems, not damage inside an individual workbook. Use Open and Repair or recover an earlier file version for a workbook-specific issue. If Excel itself fails across many files, Office repair may be relevant.
Related
- Excel MAX Between Two Dates: Find the Highest Value
- Excel Material List Template: Plan, Price, and Track
- Excel List Template Free? Where to Find and Use One
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Formulas Not Working in a Table? Fix the CauseIf Excel formulas are not working in a table, first check that the cell is not formatted as…
- Excel Sort Expand Selection Not Working? Try These FixesIf Excel’s Expand the selection option is not working, cancel the sort, select the entire data range—including every…
- Excel Text Hidden Behind the Next Cell? How to Fix ItIf Excel text looks hidden behind the next cell, it is usually still in the original cell: Excel…
- Excel Won’t Group Rows? Fix the Common CausesIf Excel won’t group rows, select the consecutive rows you want to fold, then choose Data > Outline…
- Excel Unable to Remove a Page Break? Find the Right FixIf Excel will not remove a page break, first check whether it is manual or automatic: select the…
- VLOOKUP Not Working in Excel? Show the Formula FixIf VLOOKUP appears in a cell instead of returning an answer, first turn off Formulas > Show Formulas…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.