EaseUS Data Recovery Wizard 11582 Reviews

How to Recover Corrupted Excel Files in Windows 10/11

Don't worry if you lost important Excel files after Excel corruption. This article offers you quick fixes and complete solutions to help you effectively repair and restore corrupted Excel files (Excel 2016/2007/2003 etc) in Windows 11/10/8/7 with simple clicks now.

 Free Download

Trustpilot Rating 4.7

 Free Download

Secure Download

 

Table of Contents

Followthrough any method below to repair your corrupted Excel:

Workable Solutions Step-by-step Troubleshooting
Fix 1. Restore from TMP File Find Excel temp file in C:\Users\AppData...> Locate the TMP file > Copy and change its extension...Full steps
Fix 2. Restore from Previous Version Create a new Excel with the same name and right-click it > "Properties" > "Previous Version"...Full steps
Fix 3. Recover Lost Excel Run EaseUS Fixo Document Repair > Add Excel files> Repair excel file...Full steps

Can I repair a corrupted Excel file in Windows 10

"Does anyone know how to repair a corrupted Excel file and restore all lost data in the file in Windows 10 PC? Yesterday, I was editing an important Excel file on my computer running Windows 10 when the Excel file suddenly crashed. Then I tried to open the Excel again, I got this error message 'There is a problem in this file, we couldn't open it'. Yes, the Excel file was suddenly corrupted. Is there any method that can help me to get my data back? How?"

It's no longer a new problem for Excel users to met Excel file corruption errors due to system, viruses, or other unknown reasons. So how to effectively restore corrupted Excel file and get lost data back become a new question. If you are having a similar problem, don't worry. Here we will provide two quick fixes and one complete solution to guide you in effectively restoring and repairing the file to get all your precious data back. 

Quick Fix 1. Restore corrupted Excel file from TMP file

Since Microsoft has an AutoRecovery feature that allows you to automatically save Excel files as a temp file on Windows PC. So when your Excel, Word, or PPT file suddenly corrupted or crashed, just relax and you can follow the below tips to cope with the problem.

Step 1. Follow the temp file folder location on your PC and find the Excel temp files with the TMP extension.

For Windows 8/10 users:
C:\Users\\AppData\Local\Microsoft\Office\UnsavedFiles

For Windows 7 users:
C:\Users\name\AppData\Roaming\Microsoft\Excel\ 

Step 2. Locate and find the temporary excel files that begin with "$" or "~" and end with ".TMP".

Step 3. Copy these files and save them to another safe spot by changing the extension from.TMP to .XLS/.XLSX.

Quick Fix 2. Restore corrupted Excel file from the previous version

Another quick way to restore corrupted Excel files is to restore these items from the previous version. Follow to see how to do it:

Step 1. Create a new Excel file with the same name as your lost Excel file or find your present Excel file.

Step 2. Right-click on the Excel file and select Properties.

Step 3. Go to Previous Versions, find and select the latest version or the right version before Excel crashes, deleted or saved, and click Restore.

Complete Solution: Recover lost/corrupted Excel file in Windows 10 

If the former two quick fixes don't really help, relax and just follow below 3 steps to get your lost corrupted Excel back and repair it back to work again now:

Part 1. Restore lost corrupted Excel files with file recovery software

File recovery software - EaseUS Data Recovery Wizard helps you to recover deleted, lost, or formatted Excel files from storage devices or hard drive partitions in Windows 10 with simple steps. Download and install this tool on your computer, then apply it to get the lost Excel file back now:

 Download for Win Recovery Rate 99.7%
 Download for Mac Trustpilot Rating 4.7

Step 1. Select location and click "Scan"

Choose the drive or a specific folder on Desktop or somewhere else where you lost the excel files, and click the "Scan" button.

select the location of the Excel files

Step 2. Locate your excel files

To quickly find the Excel files from the scan results, click the "Documents" option in the left panel. Choose "Excel", and click "Preview" to check if the Excel files are the wanted ones.

scan the lost excel files

Step 3. Recover Excel files

Finally, select the desired Excel files and click the "Recover" button. Then, select a folder to save the Excel files to another location.

recover Excel files

Part 2. Repair corrupted Excel files

If the restored Excel file can't be opened or fails to work, follow one of the two methods offered below to repair the corrupted Excel file:

Method 1. Use the EaseUS Fixo Document Repair to fix corrupted Excel file

EaseUS Fixo Document Repair repairs severely corrupted XLS and XLSX files and retrieves everything from the Excel workbook without modifying its original format.

 Free Download

Trustpilot Rating 4.7

 Free Download

Secure Download

Follow the steps below to repair corrupted Excel files with simple steps.

Step 1. Download and launch Fixo on your PC or laptop. Choose "File Repair" to repair corrupted Office documents, including Word, Excel, PDF, and others. Click "Add Files" to select corrupted documents.

add files to repair documents with Fixo

Step 2. To repair multiple files at once, click the "Repair All" button. If you want to repair a single document, move your pointer to the target file and choose "Repair". You can also preview the documents by clicking the eye icon.

select documents to repair

Step 3. Click "Save" to save a selected document. Select "Save All" to save all the repaired files. Choose "View Repaired" to locate the repaired folder.

save repaired documents in Fixo

Method 2. Repair corrupted Excel by saving it as another format

If you can open the corrupted Excel file with no data, try to recover the corrupted Excel by saving it in another format:

Step 1. Open the corrupted Excel file and go to Save As.

Step 2. Select Web Page from the possible file formats.

Step 3. Make sure that the whole Excel file is selected and then click Save.

Step 4. Find the saved file and right-click on it, select Open with > Microsoft Office Excel.

Step 5. If the file can be opened normally, go to Save As and choose an Excel format .xls or .xlsx.

Step 6. Change the file name so to prevent confusing it with the corrupted file and click Save.

Part 3. Recover data from corrupted Excel file

Method 1. Recover data when the workbook is open in Excel

If you can open the corrupted Excel and want to save data and formula in the corrupted Excel file in advance, just follow the tips provided in this part.

Step 1. Open the corrupted Excel file and right-click on a sheet tab > Select All Sheets.

Step 2. Right-click an Excel sheet tab and click Move or Copy.

Step 3. Choose New Book and select Create a copy box > Click OK.

Method 2. Recover data when workbook can't be open in Excel

If you can't open the corrupted Excel sheet, you may follow below two options to get data out of the Excel file:

Option 1. Set the calculation option in Excel to manual

To change the calculation settings from Automatic to Manual may help you to open the not working Excel file:

Step 1. Open Excel file and click File > New.

Step 2. Click Blank workbook under New.

Step 3. Click File > Options > Click Manual under Calculation options in Formulas category > OK.

Step 4. Find the corrupted Excel file and then double-click to open it, then you shall be able to see your saved data in Excel now.

Option 2. Use external references to link to the corrupted Excel file

Step 1. Open Office Excel and click File > Open.

Step 2. Go to the folder where the corrupted Excel is and right-click the corrupted Excel, select Copy > Cancel.

Step 3. Click File > New > Blank workbook.

Step 4. Type: =File Name!A1 in cell A1 (Replace File Name with the name of corrupted Excel file.) and then hit Enter.

Step 5. Select corrupted Excel if the Update Values box appears and click OK.

Step 6. Select cell A1 and click Home > Copy > Select an area from cell 1 to all cells that contain data in the corrupted Excel sheet.

Step 7. Click Home > Paste.

Step 8. Repeat to copy all selected cells again by clicking Home > Copy.

Step 9. Then click Home > Paste and click Values under Paste Values.

Pasting values will remove the links to corrupted excel and leave you only with the data by then. 

Was This Page Helpful?

Updated by Jaden

Jaden is one of the editors of EaseUS who lives and works in Chengdu, China. She focuses on topics concerning PCs and Mac data recovery. Jaden is committed to enhancing professional IT knowledge and writing abilities. She is always keen on new and intelligent products.

Read full bio

Written by Tracy King

Tracy became a member of the EaseUS content team in 2013. Being a technical writer for over 10 years, she is enthusiastic about sharing tips to assist readers in resolving complex issues in disk management, file transfer, PC & Mac performance optimization, etc., like an expert.

Read full bio

Product Reviews

TrustScore 4.7 | 323 reviews
  • EaseUS Data Recovery Wizard is a powerful system recovery software, designed to enable you to recover files you’ve deleted accidentally, potentially lost to malware or an entire hard drive partition.

    Read More
  • EaseUS Data Recovery Wizard is the best we have seen. It's far from perfect, partly because today's advanced disk technology makes data-recovery more difficult than it was with the simpler technology of the past.

    Read More
  • EaseUS Data Recovery Wizard Pro has a reputation as one of the best data recovery software programs on the market. It comes with a selection of advanced features, including partition recovery, formatted drive restoration, and corrupted file repair.

    Read More