Solutions to Repair Corrupt Excel File 2013
![](/images/site-logo.png)
Solutions to Repair Corrupt Excel File
Summary: MS Excel can throw various errors due to corrupted Excel files. This blog discusses the error messages that indicate Excel file corruption and the methods to prevent data loss due to a corrupt file. It also discusses the reasons behind the corruption in Excel file and their solutions. It also mentions a “Stellar repair for Excel” tool that can help to repair the corrupt or damaged Excel file.
Is your Excel file corrupted? And you don’t have backup of your data? There is no need to worry. There are some simple solutions to repair Excel file 2019. But before heading towards the solutions, let’s discuss the possible reasons for Excel file corruption and how you can prevent losing your data.
Error Messages that Indicate Excel File Corruption
When an Excel file gets corrupted, different error messages appear. For example:
- “Excel found unreadable content in
. Do you want to recover the content of this workbook, click Yes.” - “Can’t find project and library.”
- “The workbook cannot be opened or repaired by Microsoft Excel because it is corrupted.”
- “Microsoft Excel has stopped working.”
Reasons Behind Excel File Corruption
The reasons for corruption in Excel file could be any of the following:
- Improper system shutdown
- Computer virus/malware attack/Hacker attack
- Outdated anti-virus definition
- Hardware failure
- Unintentional deletion of files
- Large Excel files
- Bad sectors on storage media
How to Avoid Data Loss Due to Excel File Corruption?
Excel users should follow the below precautionary measures to prevent data loss due to Excel file corruption:
1. Create an Automatic Backup Copy
When you create an Excel spreadsheet, it is advised to Save As your document, as follows:
- In Save As window, click Tools next to Save option.
- Select General Options from the drop-down menu.
- Then check the dialogue box Always create back up and click OK.
This will always create a backup of your Excel. If it’s deleted or corrupted at any time, it can be recovered.
2. Create Recovery File at Different Time Periods
Steps are as follows:
- Go to File and then click Excel Options.
- Click Save and then select the Save Auto Recover information every checkbox
- Add the required minutes and location. Ensure that Disable AutoRecover for this workbook only box is unchecked.
Methods to Repair Corrupted Excel 2019 File
Try using these 5 methods to restore your Excel file and recover data:
Method 1: ‘Open and Repair’ Excel Files
Excel automatically opens the corrupted file in Recovery Mode. If not, you can repair Excel file manually through the following steps:
- Click on the File and select Open.
- Go to the location where the corrupt workbook is stored. In the Open window, select the corrupt file.
- Click Open and then select Open and Repair.
- In the window that opens, click Repair.
If the Repair option doesn’t work, you can select Extract Data and try to extract the values and formulae safely from the corrupt file.
Method 2: Recover Data from Open Workbook
If you face issues while working in an Excel file, you can choose to return to the last saved version of the Excel file. For this:
- Click File. Then select Open.
- Double click on the name of the workbook (the one that is open in your Excel).
- Click Yes to reopen it.
- The workbook will now appear.
Please note that it will show the last saved version and changes made after that won’t be recovered.
Method 3: Set Calculation Option as Manual
You can also recover data from Excel workbooks that you’re unable to open. For this, you need to configure the calculation option as manual in Excel. You can do this through the following steps:
- Click on File. Select New and open a Blank workbook.
- From File, select Excel Options.
- From the Formulas category, under the section Calculation options, select Manual. Now click OK.
- Then click File, and select Open to open the corrupted or damaged Excel file.
Method 4: Recover Content by Using External Links
You can also recover specifically the content (leaving formulas/calculated values) from the workbook by using external references (to link Excel workbook). For this:
- Click on File, Select Open.
- Navigate to the folder that contains the corrupted workbook.
- Now, right-click on the file name of the corrupted workbook and click Copy.
- Click File button. Then, select New and create another blank workbook.
- In the first cell (A1), type =!A1 and press Enter.
- Select the corrupted workbook in the Update Values dialogue (if it appears). Then click OK.
- Select the relevant sheet in the Select Sheet dialogue (if it appears). Then click OK.
- Again, select the cell A1, go to Home and select Copy.
- Now select (start from the cell A1) an area equal to that of the data in the original workbook.
- Go to Home now and select Paste.
- Again, go to Home, and Copy the data (the same selection of cells).
- Go to Home, and then click on the arrow below Paste. Then click on Values.
By pasting values, you removed the links to the corrupted workbook and only the data is left behind.
Method 5: Excel Repair Software
If the above-mentioned methods do not help in repairing the corrupt Excel file, try an Excel repair software.
One of the most commonly used Excel repair tools is Stellar Repair for Excel. Its trial version is available for free download, which lets you scan and preview the repaired Excel files. Once you’ve ascertained the effectiveness of the software, you can save the file after activating the software.
Here’s the complete repairing process of the corrupt Excel file
Conclusion
This post shared the reasons behind Excel file corruption and precautionary measures to prevent data loss. It also outlined different methods to repair corrupt Excel file 2019. There are several in-built utilities in Microsoft Excel to repair corrupt workbooks and recover data from it. In case these methods didn’t work, you can use Stellar Repair for Excel – an easy-to-use DIY tool that can fix all Excel corruption errors and restore data with all original properties.
Also read:
- Complete Tutorial for OnePlus 11 5G Hard Reset | Dr.fone
- How to Easily Hard reset my Samsung Galaxy XCover 7 | Dr.fone
- How To Install the Latest iOS/iPadOS Beta Version on Apple iPhone 12 Pro? | Dr.fone
- How to Reset a Vivo S17 Phone That Is Locked | Dr.fone
- Remove Google FRP lock on Xiaomi Redmi 13C 5G
- Undelete lost messages from Vivo Y17s
- How To Transfer WhatsApp From Apple iPhone 6s to other iPhone? | Dr.fone
- The way to recover deleted pictures on Lava Blaze 2 Pro without backup.
- The way to recover deleted photos on Nokia 105 Classic without backup.
- How to Factory Reset Samsung Galaxy S24 If I Forgot Security Code or Password? | Dr.fone
- How to Perform Hard Reset on Oppo Find X6? | Dr.fone
- Simple ways to get lost videos back from Vivo Y100i
- Unlock android phone if you don't have Google Pixel Fold fingerprint
- Different Methods for Resetting Samsung Galaxy M54 5G Phones with Screen Locked and Not | Dr.fone
- Turn Off Screen Lock - Xiaomi Redmi Note 12T Pro
- How to Reset Xiaomi Redmi 13C Without the Home Button | Dr.fone
- Simple ways to get lost files back from Samsung Galaxy M14 5G
- The way to get back lost music from Nord N30 SE
- How To Transfer Data From Apple iPhone 12 To Other iPhone 15 Pro devices? | Dr.fone
- How To Transfer WhatsApp From Apple iPhone 14 Pro to Android/iOS? | Dr.fone
- The Easiest Methods to Hard Reset Tecno Pova 6 Pro 5G | Dr.fone
- How do I reset my OnePlus Nord CE 3 Lite 5G Phone without technical knowledge? | Dr.fone
- Repair damaged, unplayable video files of Vivo on Windows
- How to Hard Reset Realme GT 3 Without Password | Dr.fone
- All Things You Need to Know about Wipe Data/Factory Reset For Tecno Spark 10 4G | Dr.fone
- Hard Resetting an Xiaomi Redmi Note 12 Pro+ 5G Device Made Easy | Dr.fone
- Undelete lost photos from Samsung Galaxy A05s.
- How to Reset a Honor Magic 6 Pro Phone That Is Locked | Dr.fone
- Hard Resetting an Xiaomi 13T Device Made Easy | Dr.fone
- The way to recover deleted contacts on Xiaomi Redmi Note 12R without backup.
- The 5 Best Methods to Track a Lost or Stolen iPhone 13 Pro Max | Stellar
- How to Reset a Poco X5 Phone That Is Locked | Dr.fone
- Your Complete Guide To Reset Lava Blaze Curve 5G | Dr.fone
- Complete Tutorial for Oppo A56s 5G Hard Reset | Dr.fone
- How do I reset my Oppo Find N3 Phone without technical knowledge? | Dr.fone
- Is your Xiaomi Redmi K70E working too slow? Heres how you can hard reset it | Dr.fone
- How to Easily Hard reset my Samsung Galaxy M54 5G | Dr.fone
- How to Factory Reset Motorola Moto G Stylus (2023) in 5 Easy Ways | Dr.fone
- Is your Sony Xperia 10 V working too slow? Heres how you can hard reset it | Dr.fone
- How to Reset a Vivo V29 Pro Phone That Is Locked | Dr.fone
- How to Reset a Honor Magic5 Ultimate Phone That Is Locked | Dr.fone
- Repair damaged, unplayable video files of Vivo on Mac
- What To Do if Your Tecno Phantom V Flip Auto Does Not Work | Dr.fone
- Nubia Red Magic 8S Pro Camera Not Working Unexpected Error? Fix It Now | Dr.fone
- In 2024, Latest way to get Shiny Meltan Box in Pokémon Go Mystery Box On Realme 11X 5G | Dr.fone
- In 2024, How To Unlock Apple iPhone 12 Pro Max Official Method to Unlock Your Apple iPhone 12 Pro Max
- Easy steps to recover deleted call history from Realme GT 5 Pro
- 11 Proven Solutions to Fix Google Play Store Not Working Issue on Motorola Moto G14 | Dr.fone
- In 2024, Create Stunning Animations Top iOS and Android Stop Motion Apps
- How and Where to Find a Shiny Stone Pokémon For Samsung Galaxy S21 FE 5G (2023)? | Dr.fone
- How to retrieve erased messages from Realme
- In 2024, Getting the Pokemon Go GPS Signal Not Found 11 Error in Poco X5 | Dr.fone
- Remove Google FRP Lock on Nord 3 5G
- In 2024, The 6 Best SIM Unlock Services That Actually Work On Your Vivo Y77t Device
- A Working Guide For Pachirisu Pokemon Go Map On Sony Xperia 10 V | Dr.fone
- Title: Solutions to Repair Corrupt Excel File 2013
- Author: Ian
- Created at : 2024-05-20 10:20:29
- Updated at : 2024-05-21 18:20:57
- Link: https://techidaily.com/solutions-to-repair-corrupt-excel-file-2013-by-stellar-guide/
- License: This work is licensed under CC BY-NC-SA 4.0.