If you are asking how do i repair excel, you are probably staring at an error that says the file is corrupt, the workbook will not open, or Excel freezes the moment you click a cell. Take a breath. In most cases your data is still sitting inside the file, and Microsoft built several recovery tools to get it back. This guide walks through each fix in the order that works best.
If you are asking how do i repair excel, you are probably staring at an error that says the file is corrupt, the workbook will not open, or Excel freezes the moment you click a cell. Take a breath. In most cases your data is still sitting inside the file, and Microsoft built several recovery tools to get it back. This guide walks through each fix in the order that works best.
The phrase 'repair Excel' actually covers two very different problems. Sometimes a single workbook is damaged while the program itself is healthy. Other times Excel the application is broken, so every file misbehaves, add-ins crash on launch, or the ribbon disappears. Knowing which problem you have saves hours, because the fixes for a damaged file and a damaged installation have almost nothing in common.
A quick test tells you which one you face. Open a brand new blank workbook and type a few numbers. If that works normally, the program is fine and your problem lives in one specific file. If the blank workbook also crashes, hangs, or throws errors, the installation, an add-in, or your user profile is the likely culprit. Start there before touching any damaged file, so you do not waste effort.
For damaged files, the golden rule is to work on a copy. Before you try any repair, right-click the workbook in File Explorer, copy it, and paste it somewhere safe such as your desktop. Every recovery method below can change the file, and a few can overwrite good data with partial data. A pristine backup copy means you can always return to the original and try a different approach.
Timing matters too. The longer a corrupt file sits open in a crashing Excel session, the greater the chance that AutoRecover overwrites a useful earlier version. If Excel is still running and showing strange behavior, resist the urge to keep clicking. Close other programs, note exactly what you were doing, and move straight into the recovery steps so you preserve whatever clean data remains on disk.
Many people also wonder whether they need to reinstall Office. Usually you do not. Excel includes a built-in Quick Repair and Online Repair, an Open and Repair command for individual files, and a Safe Mode that bypasses add-ins. Those three tools solve the large majority of problems, and they take only a few minutes. A full reinstall is the last resort, not the first move.
Once Excel is working again, you may want to confirm that macros still run, since some repairs reset security settings. Our walkthrough on how to repair excel macro problems pairs well with this guide and shows how to restore automation safely. By the end of this article, you will know how to diagnose, recover, and protect your spreadsheets for good.
Open a new blank workbook and enter a few values. If it behaves normally, your problem is a single damaged file. If it crashes too, the program, an add-in, or your profile is at fault, and you should skip ahead to the application fixes.
Duplicate the problem workbook and work only on the copy. Every repair method can alter data, so a clean original lets you retry with a different tool if the first attempt recovers only part of the content.
In Excel choose File, Open, Browse, select the file, click the arrow beside Open, and pick Open and Repair. Start with Repair, which restores as much as possible. If that fails, repeat and choose Extract Data.
Hold Ctrl while launching Excel, or run excel /safe from the Run box. Safe Mode skips add-ins and startup files, so it quickly shows whether a faulty add-in causes crashes or slow opening.
Open Settings, Apps, find Microsoft Office, choose Modify, and run Quick Repair first. If problems remain, run Online Repair, which downloads fresh files and fixes deeper installation damage but takes longer.
A corrupt workbook usually announces itself with a message such as 'We found a problem with some content' or 'Excel cannot open the file because the file format or extension is not valid.' Corruption happens when a save is interrupted, a network drive drops mid-write, a USB stick is removed too soon, or a power cut hits during a large save. The file structure becomes inconsistent, and Excel refuses to trust it.
The most reliable first move is Open and Repair. Launch Excel without opening the file, go to File, Open, Browse, and select the workbook. Click the small arrow next to the Open button and choose Open and Repair. Excel then offers two buttons. Repair attempts to rebuild the file while keeping formulas, formatting, and charts, and it succeeds more often than most people expect.
If Repair reports that it could not complete, reopen the file with the same command and choose Extract Data instead. This mode gives you a choice between converting formulas to values or recovering formulas as they were. Pick Recover Formulas first. If formulas fail, accept values only. You lose live calculations, but you keep the numbers, labels, and layout, which you can rebuild with new formulas afterward.
Another trick is changing how the file is read. Create a blank workbook, then use Data, Get Data, From File, From Workbook to point at the damaged file. Power Query often reads sheets that the normal open routine rejects. You can load each worksheet into the new file as a table. The structure of formulas will not transfer, but raw rows and columns usually will.
You can also rename the extension. An XLSX file is really a ZIP archive of XML parts. Make a copy, change .xlsx to .zip, and open it with File Explorer. Inside the xl/worksheets folder you will find sheet1.xml, sheet2.xml, and so on. If only one part is damaged, you can copy the healthy parts into a fresh archive, rename it back, and open it.
Linked files cause their own trouble. A workbook that pulls from external references can display errors or prompt endlessly even when it is intact. Use Data, Edit Links, then choose Break Link or Update Values to calm the prompts. Once the workbook opens cleanly, check that a vlookup excel formula still returns the correct values, because a broken link silently turns lookups into #REF! errors.
When none of these work, look for earlier versions. Right-click the file in File Explorer, choose Properties, and open the Previous Versions tab if Windows File History or restore points are enabled. OneDrive and SharePoint also keep version history, reachable from the file's menu. Restoring a version from an hour ago often beats fighting a damaged file, and you only lose the latest edits.
AutoRecover quietly saves temporary copies of open workbooks every ten minutes by default. After a crash, Excel usually shows a Document Recovery pane on the next launch with the saved versions listed by time. Pick the newest version, save it under a new name immediately, and compare it to your last manual save so you know exactly which edits survived.
If the pane never appears, look in the AutoRecover folder yourself. Go to File, Options, Save and copy the AutoRecover file location path into File Explorer. Look for files ending in .xlsb or folders named after your workbook. You can also use File, Info, Manage Workbook, Recover Unsaved Workbooks to browse recent unsaved drafts that Excel retained.
If your workbook lives in OneDrive, SharePoint, or Teams, version history is the strongest safety net you have. Open the file in Excel, click the file name at the top, and choose Version History. Excel lists earlier saves with dates and authors. Open an older version, confirm the data looks right, and click Restore to make it the current copy.
On a local drive, Windows can help when File History or System Protection was turned on beforehand. Right-click the file, open Properties, and select Previous Versions. Choose a snapshot from before the problem began and copy it to a new folder rather than overwriting. This method saves lost work only if protection was enabled before the damage occurred.
Dedicated recovery utilities can read the raw structure of a damaged workbook when Excel itself gives up. Many offer a free preview that shows recoverable sheets before you pay, which lets you judge whether the tool can actually help. Always download from the vendor's official site, scan the installer, and never upload confidential data to unknown online services that promise instant repairs.
Free alternatives are worth trying first. LibreOffice Calc opens many damaged XLSX files that Excel refuses, and Google Sheets can import a workbook and let you export a clean copy. Neither preserves every feature, such as complex pivot tables or macros, but they frequently rescue the underlying numbers, text, and basic formatting in minutes.
After any successful repair, use Save As with a new file name and a fresh XLSX format before you edit anything. Overwriting the original removes your only fallback and can lock in hidden damage. Keep the damaged original untouched until you have verified every sheet.
When every workbook misbehaves, the program itself needs attention. Start with Safe Mode, because it takes seconds. Hold the Ctrl key while clicking the Excel icon and confirm the prompt. Safe Mode loads Excel without add-ins, custom toolbars, or startup files. If Excel now runs smoothly, an add-in is to blame, and you can disable them one at a time through File, Options, Add-ins.
COM add-ins and old third-party tools cause most unexplained crashes. In Options, open Add-ins, choose COM Add-ins from the Manage list, and click Go. Uncheck everything, restart Excel, then re-enable add-ins one by one until the crash returns. The last one you turned on is the culprit. Update it from the vendor, or leave it disabled if you no longer need it.
If Safe Mode does not help, run Office Repair. On Windows, open Settings, then Apps, then Installed apps, find Microsoft 365 or Office, click the three dots, and choose Modify. Select Quick Repair, which runs offline and finishes in a few minutes. Quick Repair replaces damaged program files without touching your documents or settings, so it is safe to try early.
Online Repair is the heavier option. It uninstalls and reinstalls Office components using fresh files downloaded from Microsoft, so you need a stable internet connection and roughly twenty to forty minutes. Save your work and close every Office program first. Your documents stay intact, but some custom settings, such as ribbon customizations or default fonts, may reset, so note them down before you begin.
Display problems have their own fixes. If Excel looks blank, flickers, or draws grid lines incorrectly, open File, Options, Advanced and tick Disable hardware graphics acceleration. Update your graphics driver as well. These changes resolve a surprising number of 'Excel not responding' complaints on laptops with hybrid graphics, especially after a Windows update changes how the display driver talks to Office.
On a Mac, the process differs slightly. Quit Excel, then use Microsoft AutoUpdate to install pending updates, since many Mac crashes are fixed in routine patches. If problems persist, remove the Excel preferences file from the Library folder, restart, and let Excel rebuild it. As a final measure, drag Excel to the Trash and reinstall it from your Microsoft account, which keeps your files untouched.
After the application is healthy again, test the features you rely on. Try how to merge cells in excel on a small range, confirm that how to freeze a row in excel works from the View tab, and check that how to create a drop down list in excel still functions through Data Validation. A quick tour like this proves the repair worked and reveals any lingering gaps early.
Prevention beats repair every time. Start by turning on AutoRecover with a shorter interval. Open File, Options, Save, and change 'Save AutoRecover information every' from ten minutes to two or three. Also tick 'Keep the last autosaved version if I close without saving.' These two small changes mean a crash costs you minutes of work rather than an entire afternoon of edits.
Save to a local drive, then copy to the network. Many corrupt files come from saving directly onto a flaky network share or a removable USB drive that was unplugged mid-write. Work on a local copy, finish, and then copy the final version to the shared location. If you use OneDrive, let the sync icon finish before closing your laptop lid or shutting down.
Keep file size under control. Workbooks with tens of thousands of formatting-only rows, hundreds of unused styles, or thousands of hidden shapes bloat and become fragile. Press Ctrl+End to find the real last cell, delete empty rows and columns beyond your data, and save. Consider saving huge, formula-heavy files as XLSB, the binary format, which is smaller, faster, and generally more resilient than XLSX.
Avoid chains of external links where possible. A workbook that pulls from five other workbooks, each pulling from more, breaks whenever one is moved or renamed. Where you can, paste values or load source data with Power Query instead. If your workbook relies on a vlookup excel formula pointing at another file, consider consolidating that lookup table inside the workbook to remove the dependency entirely.
Keep Office updated. Microsoft patches stability and file-handling bugs monthly, and a build that is a year old may contain a defect already fixed. Check File, Account, Update Options, and choose Update Now. Also keep Windows updated, and keep antivirus software from scanning the Excel temp folder in real time, since aggressive scanners sometimes lock files during saves and cause partial writes.
Build a simple backup routine. Follow the 3-2-1 rule: three copies of important data, on two different media types, with one stored offsite or in the cloud. For workbooks you edit daily, save a dated copy at the end of each day, such as Budget_2026-10-13.xlsx. Disk space is cheap, and a folder of dated snapshots makes any repair question easy to answer.
Finally, practice good habits when closing. Do not force-quit Excel while it is saving, do not pull power during a save, and avoid opening the same workbook on two machines at once without co-authoring. Those habits cost nothing. Combined with versioned cloud storage and sensible add-in hygiene, they make the question 'how do I repair Excel' something you rarely need to ask.
Practical habits make repairs faster when trouble does strike. Keep a short troubleshooting note near your desk listing the exact order of fixes: copy the file, Open and Repair, Safe Mode, Quick Repair, Online Repair. When panic sets in, a written sequence prevents you from skipping steps or trying risky shortcuts. Teams benefit especially, because everyone follows the same proven path instead of improvising under deadline pressure.
Read error messages carefully and write them down. Phrases such as 'file format or extension is not valid,' 'unreadable content,' or 'out of memory' each point to different causes. An invalid extension suggests the file was renamed or truncated during download. Unreadable content points to damaged XML. Out of memory often means you have too many volatile formulas or a 32-bit install handling a huge model.
Check the file size. A workbook that should be a few hundred kilobytes but reads zero kilobytes is empty, and no tool can restore content that never reached the disk. A file that is suddenly far larger than before may contain runaway formatting. Compare against an older backup. Size changes give you a clue about whether you are dealing with truncation, bloat, or something else.
If email attachments arrive broken, ask the sender to resend as a ZIP file or share a cloud link. Some mail gateways alter attachments, and Excel files blocked by security software may arrive incomplete. Also check Protected View. Files downloaded from the internet open read-only until you click Enable Editing, and some people mistake that banner for corruption when the file is perfectly healthy.
Know when to stop. If you have spent more than an hour on one file, step back and weigh the cost. Compare the value of the data against the price of professional recovery services, which often charge a flat fee after a free assessment. For business-critical financial models, hiring a specialist early can be cheaper than hours of trial and error that risk overwriting remaining recoverable data.
After recovery, audit the result. Compare totals against a printed report or earlier email. Spot-check formulas, defined names, data validation lists, conditional formatting, and charts. Test macros if the file was XLSM. Use Formulas, Error Checking to scan for broken references. A repaired workbook that looks right but calculates wrongly is worse than an obviously broken one, so verification is not optional.
Finally, keep learning. The more comfortable you are with Excel's features, the less likely you are to cause damage and the faster you diagnose problems. Practice with realistic questions, review how formulas, lookups, and validation work, and revisit fundamentals regularly. Skills built through practice make you the person colleagues call when a workbook breaks, and that confidence is worth far more than any single repair trick.