How To Repair An Excel Workbook

Does your Excel workbook refuse to get open up or each time when you try to open your Excel workbook it suddenly starts showing errors?

If you all are rendering such issues with your Excel spreadsheet then information technology's a clear indication that your Excel workbook has now got corrupted. Now the question arises on how your Excel file got corrupted and how to recover corrupted Excel file 2022/2019 data.

Well to get an answer to such a question, you need to go through this post. Equally here in this article, I will requite you all the consummate information well-nigh Excel file corruption. Such as the root causes of corrupted Excel file and how to recover corrupted Excel file 2022.

To recover corrupted Excel file data, we recommend this tool:

This software will prevent Excel workbook data such as BI data, financial reports & other analytical data from corruption and data loss. With this software you can rebuild corrupt Excel files and restore every single visual representation & dataset to its original, intact state in 3 easy steps:

Download Excel File Repair Tool rated Excellent past Softpedia, Softonic & CNET.
Select the corrupt Excel file (XLS, XLSX) & click Repair to initiate the repair process.
Preview the repaired files and click Relieve File to relieve the files at desired location.

And then, merely relax and read the article thoroughly to repair corrupted Excel files as well equally how to recover Excel file data.

Best Excel File Recovery Software

Y'all can make use of the best ever Excel File Recovery Tool to repair and recover corrupted, damaged, or inaccessible Excel files. This is capable to fix Excel file corruption issues and various errors encountered by the users. It allows us to hands restore entire data including the charts, worksheet properties cell comments, and other data.

* Free version of the product only previews recoverable data.

This is a unique tool to repair multiple Excel files at one repair bike and recover the unabridged data in the preferred location. It is piece of cake to use and supports all Excel versions.

Why To Choose Excel File Recovery Software ?

Recovers any type of corrupted Excel xls/xlsx files instantly
Not just repair XLS/XLSX files but also fixes several Excel errors
Easily restore Excel worksheet data similar chart, formula, nautical chart canvas, table, image, and much more…
Retains the structure originality of your corrupted Excel workbook in the recovered file.
Performs quick Excel file recovery
well supports for MS Excel 2022/ 2022/ 2022/ 2010/ 2007/ 2003/ XP/ 2000/ 97/ 95 versions.

Steps to Utilize Excel File Recovery Tool:

How To Recover Corrupted Excel File?

How To Recover Corrupted Excel File

Later getting an thought of how to identify corruption of Excel file and the master causes of Excel file corruption. Information technology's time to motility on to our side by side section i.e how to recover corrupted Excel file 2022/2019.

Have a look over the list of methods we are going to discuss for easy recovery of corrupted Excel file 2022.

1: Use Open and Repair Tool

two: Restore corrupted Excel file from TMP file

3: Restore From File Recovery

four: Revert Workbook to last Saved Version

five: Disable Automatic Calculation

6: Try Microsoft Office Tools

7: Move The File

8: Recover Corrupt Excel By Saving as Another Format

9: Apply External References to Link to the Corrupted Workbook

Permit'southward get-go discussing each of these methods on how to recover corrupted Excel file 2022 deeply….!

Solution 1: Use Open And Repair Tool

Make use of the inbuilt Open and Repair tool to repair decadent Excel files.

Effort the given pedagogy to practice and then:

Open Excel sheet > click File > Open.
Now select the corrupted Excel file
And click the pointer next to the Open button > Click Open and Repair.

repair corrupt excel file

If this is your offset attempt at manually recovering the workbook > click Repair in the resulting dialog box.

open and repair tool

I Promise Excel will repair the file, only if something goes wrong, Excel will not recover any data from the decadent Excel workbook.
Well, in this example, click the second option Extract Data

All the same, in many cases, information technology is seen this fails to repair the severely damaged or corrupted Excel file.

So, in this case, brand use of the professional recommended Excel File Repair Tool, to recover corrupted Excel files.

Solution two: Restore Corrupted Excel File From TMP File

Microsoft is having an AutoRecovery feature that allows automatically saving Excel files just like a temp file on the Windows operating organization.

So, that if in instance the MS office applications such as Excel, PPT or Word file gets crashed or corrupted, you lot can recover it.

Follow the steps to practise so:

Open the binder where your temp file is stored on your PC. Later then locate the temp files of Excel having extension .tmp.

The Windows 8/10 users:

Go to – C:\Users\\AppData\Local\Microsoft\Role\UnsavedFiles

The Windows seven users:

Become to – C:\Users\name\AppData\Roaming\Microsoft\Excel\

Locate the Excel temp files starting with "$" or "~" > and ending with ".TMP".
Re-create the files > salvage to another Safe location > change the file extension from .TMP to .XLS/.XLSX.

And y'all canrestore corrupted/damaged XLS/XLSX file easily.

Solution 3: Restore From File Recovery

The File recovery is the culling backup, which means this is a file that contains entire Excel data as if the original workbook gets damaged or corrupted the data can be accessed from in that location.

And when the Excel file gets corrupted and tries to open a corrupted workbook, Excel engages the File Recovery manner that tries to repair the workbook.

You tin can create a recovery file automatically during intervals.

Follow the given instructions:

Open up Excel > click File > Options
Then in the Excel Options dialog box > Save > cheque every box of the Save AutoRecover data > and as per your recommendation fix the time limit (the default is 10).

Provide the location where you want to relieve the recovery file in the AutoRecover file location box.

Please Annotation: Make certain the Disable AutoRecover for this workbook-merely box is unchecked.

In many cases, the Excel automatic File Recovery mode or Autorecover fails to recover corrupt Excel file. If this happens and so try the below-given solution.

Solution 4: Revert Workbook To Last Saved Version

When the workbook gets corrupted at the fourth dimension you are working then the best thing to recover corrupted Excel file is reverting the workbook to the last saved version.

Follow the steps to do and so:

First, click File > Open up.
And double-click on the name of the workbook that you lot have open in Excel.
Side by side click Yeah to reopen the workbook.

Doing this volition open the workbook without whatever modification made by you, but doing this will open up the Excel file and data stored in it.

Solution 5: Disable Automatic Calculation

If Excel fails to open the file on its own or through the Open and Repair option, and so, in this case, try changing the calculation from automatic to manual. As the workbook won't recalculate in this case and might open.

Follow the steps to exercise then:

Open a new blank workbook.
Click File > Options > in Formulas category > under Calculation option
Then click Manual > click OK.

Side by side click File > open up
At present locate the workbook > double-click corrupted workbook to open information technology.

And cheque if this repair corrupt Excel file then recovers the entire information stored in information technology.

Solution half dozen: Endeavor Microsoft Office Tools

If yous are not able to open the corrupted workbook, then endeavour the Microsoft Role Tools to recover corrupted Excel file data.

Follow the steps to do then:

Click the Start menu > select All Programs
Then choose Microsoft Function > Microsoft Function Tools.
Now choose Microsoft Office Awarding Recovery.
And in the resulting dialog box > choose Microsoft Function Excel.

Adjacent click Recover Awarding.
The whole process takes a few minutes and responds to the Send Report to Microsoft prompt.

The recovery tool closes the Excel file restarts it and displays the listing of the recovered workbook. I promise this helps you to recover corrupted Excel file information.

Solution vii: Move The File

In some cases, the corrupted workbook is not really corrupted merely becomes inaccessible. The networks and servers often cause abuse and decadent the files.

If your Excel file becomes inaccessible and Excel won't repair than move the corrupted file to another drive, folder or server.

Solution eight: Recover Decadent Excel Past Saving Equally Another Format

You can endeavour these like shooting fish in a barrel tricks to recover corrupted Excel file data:

Open corrupted Excel file > go to Salvage As.
And cull Spider web Page from possible file formats.
Check if the entire Excel file is selected > click Save
Locate the saved file > right-click on it > select Open with > Microsoft Office Excel.
If file won't opened normally > get to Save Every bit > select an Excel format .xls or .xlsx.
And change the file proper noun to preclude defoliation > click Save

In, this example you tin can recover corrupted Excel file.

It is estimated the given solutions volition help you lot to repair and recover corrupt Excel file information.

Solution 9: Utilize External References to Link to the Corrupted Workbook

Well, you can effort to recover data just without formulas or calculated values from the workbook, try using external references to link corrupted workbooks.

Follow the steps to do so:

Click File > Open > and go to the folder that contains a corrupted workbook.
And so correct-click the file name of the corrupted workbook > click Re-create > Cancel.
Now click File > New > click Bare workbook.
In cell A1 of new workbook > type =File Name!A1, ( FileName is the name of the corrupted workbook copied earlier) > press Enter.

Please Note: But enter the proper noun of the workbook, don't blazon the file name extension.

If Update Values dialog box appears > choose corrupted workbook > click OK
If Select Sheet dialog box appears > cull advisable sail > click OK
Select jail cell A1 > click Dwelling > Re-create
Now choose an area starting in cell A1 that is approximately the same size as the range of cells that hold data in the corrupted workbook.
Click Domicile > Paste
And with the range of cells still selected, click Dwelling house > Copy
Click Home > Paste > under Paste Values > click Values
The pasting values remove the links to the corrupted workbook and go out the data only.

[BONUS TIP]: Automatically Salve Fill-in Re-create Of A Workbook

I always recommend backup your Excel data, so that y'all tin access your data if in case your Excel workbook gets corrupted or deleted.

Follow steps to automatically save the backup copy of your workbook:

Click File > Save As.
Then click Computer > click Browse button.
In the Save Every bit dialog box, click the arrow next to Tools.

save backup copy of excel workbook 1

From the drop-down option of tools choose the General Options.

save backup copy of excel workbook 2

At present in opened General options dialog box, check Always create fill-in pick.

save backup copy of excel workbook 3

FAQ's Related To Excel File Corruption:

What is Excel File Corruption?

MS Excel is used worldwide by professionals and organizations for calculating, maintaining data, keeping records, and track.

Simply there are many cases seen when the Excel file gets you on the nerves.

Usually the Excel macros and formulas go haywire and make everything worse, corrupting the entire information stored in the workbook.

Well, this is the most frustrating situation equally a modest corruption in the Excel workbook makes the entire data stored in information technology inaccessible. And as a result, you are not able to access the data stored in an Excel file.

How To Identify Abuse Of Excel File?

What Causes Excel File Corruption?

There are many causes seen responsible for Excel file corruption. Here cheque out the most mutual one:

Due to the sudden closing of the opened Excel workbook
Unexpected Excel crash
Due to a virus/malware infection
Mistakenly using the Excel file
Excel application defection.
Unexpected system shutdown
Bad sector in the Excel workbook

To repair corrupted Excel workbook, Microsoft hasn't offered any manual solution but an inbuilt Open and Repair utility available in Excel files.

Despite this, at that place are many other manual ways you can use to recover corrupted Excel file. Beneath check the detailed process.

Conclusion:

So, this is all well-nigh how to recover corrupted Excel 2022 file.

Attempt the given solutions one by ane and check if this helps you to restore corrupted/damaged XLS/XLSX file.

Additionally, Excel is an essential application and used in daily life, and then information technology is recommended to handle the Excel file properly and follow the best preventive steps to protect your Excel files from getting corrupted.

Despite this it, is always recommended to create a valid backup of your crucial Excel information and besides browse your system with a practiced antivirus program for virus and malware infection.

If, in example you have whatsoever additional questions apropos the ones presented, do tell us in the comments section below.

Good Luck….

Summary

9 Effective Ways To Recover Corrupt Excel File Data

Article Name

9 Effective Ways To Recover Corrupt Excel File Data

Description

Go nine best fixes to recover decadent Excel File 2022 information. Also catch data on how to identify Excel file corruption and root causes backside corruption of Excel workbook.

Author

Sandra Louis

Publisher Proper noun

Repair MS Excel Weblog

Publisher Logo

Margret Arthur is an entrepreneur & content marketing expert. She writes tech blogs and expertise on MS Office, Excel, and other tech subjects. Her distinctive fine art of presenting tech data in easy to empathize linguistic communication is very impressive. When not writing, she loves unplanned travels.