WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Excel Repair Files

Excel Repair Files

Top 4 Ways to Repair Corrupted Excel Files

Corrupted Excel File is a mayhem message for any excel user. After putting all the hard work if the file is corrupted, then it will create panic for the user. So, how do you deal with these corrupted files? In this article, we will provide you some of the techniques to deal with corrupted files. Read the entire article to learn about repairing corrupted excel files.

Excel-Repair

#1 Repair the Workbook Manually

Once the excel file is corrupted and if you try to reopen it, excel, by default, starts the file recovery mode, tries to reopen the file along with repairing the workbook.

If you are not able to open the excel file because it is corrupted, we can repair the workbook through a manual process.

Follow the below steps to repair the corrupted excel workbook manually.

Step 1: Open one blank workbook. Click on the FILE tab.

Step 2: Now click on the OPEN option and choose the “Browse” option.

Excel Repair Browse Option

Step 3: From this Browse window, locate the file which is corrupted.

Open File Option

Step 4: In the same window, click on the dropdown list of “OPEN” and choose “Open and Repair.”

Open and Repair Option

Step 5: Now, excel shows the below message box.

Excel Repair Msgbox

In the above window, we can see two options.

  • Repair if you want to recover as much of your work as possible. So to select this option, you need to click on the “Repair” option.
  • Extract Data if Excel was previously unable to repair the workbook. So to select this option, you need to click on the “Extract Data” option.

Now, if the excel was able to repair the workbook successfully, then we will get the below information message.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Excel Repair Example 1.1

Now in the newly opened workbook, you can see the status of the workbook as “Repaired.”

Excel Repaired File

#2 Recover Data from Opened Workbook

If you have not been able to save the latest work from the workbook, then you can recover the last saved version data from the corrupted workbook.

Click on the FILE tab and choose an OPEN option from another workbook.

Excel Repair Browse Option

Now select the excel workbook that you want to repair.

Open File Option

Click on Yes to reopen the workbook.

Now from this file, you can recover the data until the time it last auto recovered.

#3 Setting Calculation to Manual

Recover Data from Corrupted Workbook By Setting Calculation to Manual

If you are not able to repair the corrupted excel workbook, then you can recover the data by setting the calculation mode to manual. Follow the below steps to recover data from a corrupted workbook that was not repaired.

Step 1: Open blank workbook.

Step 2: In the blank workbook, click on FILE >>> Options.

autosave in excel example 1.1

Step 3: In the Excel Options window, go to “Formulas.” Under Calculation options, choose the workbook calculation to “Manual.”

Excel Repair Example 3.3

Step 4: After this, click on the Ok. Now go to file and open the corrupted excel file to recover the data from the corrupted file.

#4 Create Backup Copy of Workbook Automatically

Having the backup copy of all the workbooks is gold to have, isn’t it???

We can instruct the excel workbook to create a backup copy of all the workbooks we work with automatically. Follow the below steps to apply this setting change.

Step 1: Open any of the workbooks.

Step 2: Click on Save As in the excel button or press the F12 key.

F12 Key

Step 3: In the Save As window, click on the drop-down list of the “Tools” option and select “General Options.”

Excel Repair - General Options

Step 4: This will open up the “General Options” window, and in the below window, check the box “Always create backup.”

Create Backup Option

In the above window, you can also choose the passwords to “Open” and “Modify.” So if anybody opens other than you, then they must enter the password to open and modify the workbook.

Note: This setting is applicable only to this workbook. Any other workbooks remain the same.

Things to Remember

  • If you have struggled with corrupted files and not able to recover, then you can use third-party software that can repair your excel workbook instantly.
  • Always create a backup copy of anticipated corrupting files.
  • To have auto-recovery files at various stages of the workbook, set the auto-recovery timing.

Recommended Articles

This has been a guide to Excel Repair. Here we discuss how to repair corrupted excel files in 4 ways – 1) Repair Manually 2) Recover Data from Opened Workbook 3) Setting Calculation to Manual 4) Create Backup Copy. You can learn more about excel from the following articles –

  • AutoRecover in Excel
  • Enable Macros in Excel
  • Track Changes in Excel
  • XML in Excel
  • Last Day of the Month in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More