How to Repair Corrupt Excel File Error in Excel 2013

"We found a problem with some content in . Do you want us to try recover as much as we can? If you trust the source of this workbook, click yes"

Part 1: What is the Error cause Excel File get Corrupted

The cause of the error, are usually due to:

A few scenarios where Excel sheet gets corrupted are as below:

  1. Improper shutdown of the system: Many times computer system undergo sudden shutdown due to power supply failure or any similar reason. However, shutting down the system normally but without properly closing all the running applications may also cause damaging effects to files and data to a similar degree. MS Excel files also get damaged or corrupted due to such reasons.
  2. Virus: Computer viruses which are programs maliciously designed to infect source or data files on a computer, often at a very large scale. A computer system contaminated with the virus can be a cause of Excel files getting corrupted.
  3. Bad sectors on a storage device: The storage devices e.g. hard drive (local), hard drive (external) pen drive, etc. may get developed bad sectors over some period of time, which is basically a hardware problem, Excel sheet on these bad sectors of storage media can get corrupt.
  4. Improper handling of MS Excel: An unexpected closing of Excel sheet or improper closing of an opened file can be a cause of corrupted Excel file.
  5. Large data size: Basically MS Excel is not meant for handling huge data as it is not a database, therefore, chances of corruption become more if you overload excel file to contain a large amount of data.
  6. Software conflict: Sometimes software conflicts as well as, rarely, though, printing excel file may also be the cause of damaging excel files.
  7. Macros and Formulas: Excel Macros and complex formulas also have a known bad reputation of creating corrupted data in a working worksheet.

Part 2: With 'Open and Repair' feature to Repair corrupt Excel file

To repair Excel workbook (Excel 2013) with the type of error message: "We found a problem with some content in <filename>. Do you want us to try recover as much as we can? If you trust the source of this workbook, click yes"

That appears with Excel 2007/2010 as well, there are five methods to recover corrupted file.

1. Restore (from Backup). The file can be restored from the backup whereas backup must be maintained automatically.

2. Restore (from Recovery file). This is an alternative to backup, a file comprising all the Excel data that you can fetch back even if data is deleted or damaged accidentally. To do this mark ‘check’ in every box of “Save AutoRecovery” in the Excel Options, except ‘Disable AutoRecover’.

3. Recover from Office Document. This option is available only when the file is slightly affected. In the task pane of documentary recovery, arrow near recovered file may be clicked and ‘Save AS’ option enables recovery.

4. Open and Repair” feature. Excel automatically starts attempting recovery is the case it detects any corrupt Excel 2013 file, as the facility is provided in MS Excel itself. But failure to this mode, manual recovery is achievable by “Open and Repair” feature. Follow these steps.

5. Third-party Tools.

In case none of these options recover Excel 2013 file properly, best professional Excel Repair software ‘Stellar Phoenix Excel Repair’ should be used to fix all errors.

Part 3: Repair MS Excel File with Excel Repair Tool

Stellar Phoenix Excel Repair is an Excel file repair software. The demo version is free to let the novice experience comfortably. It is a must have excel file repair software that flawlessly repairs corrupted excel file. This excel file repair software offers two licensed versions, one for a single user and other for multiple systems are available supporting Mac (Excel2011) and all versions of windows.

Microsoft Excel Repair Tool
  • Repairs all kind of data stored in damaged excel file such as tables, charts, formulas, comments, images, etc.
  • Restore all of your corrupted excel files to their original standing.
  • Preview the repaired excel file in real-time,see how much of the file has been recovered as it is being repaired.
  • All kind of MS office corruption errors (for XLS and XLSX files only) can be handled with this tool.
  • This excel file repair tool can be used on both windows and Mac platforms in order to repair corrupt excel file.
  • All kind of MS office corruption errors (for XLS and XLSX files only) can be handled with this tool.
  • This excel file repair tool can repair damaged files of all versions from 2000 to 2016 that includes 2000, 2003, 2007, 2010, 2013, etc.

Simple steps to perform Excle File Repair

For Windows, the following sequence of steps may be followed to easily repair corrupted excel file, corrupted or damaged. For Mac, the option is there and can be used the same way. This Excel file repair software works equally well on either of the two to repair corrupted excel file.

Step 1

repair damaged Excel file step 1

Step 2

repair damaged Excel file step 2

Step 3

repair damaged Excel file step 3

Step 4

repair damaged Excel file step 4

Part 4: Tips to Repair Corrupted Excel File

Case 1. When Excel cannot open the file

  1. Copy and open corrupt file on hard-drive.
  2. Find .xlb file. Also keep a backup as well. Delete .xlb. Restart Excel.
  3. Try opening the file in MS word or Notepad. However, that will let you recover data but not formatting
  4. Use Excel XP. This has better options for recovery.
  5. When attempting opening file, disable macros
  6. Click start running Excel in safe mode and then enter “C:\Program file\Microsoft office\office\excel.exe”/s

Case 2. When Excel file is open

  1. Try on a different computer
  2. Switch off Auto-save.
  3. Turn off the file sharing option
  4. Don’t run Excel from a floppy
  5. Save the file as a web page and reopen it as Excel file.
  6. Decrease size of Excel file
  7. Go back to the last version of the file saved.

Precautionary Tips to avoid excel file get corrupted

Hot Articles
See MoreSee Less
Home / Office Document Repair / How to Repair Corrupt Excel File Error in Excel 2013

All TOPICS

Top

You are visiting computer data recovery page, if you want to recover your mobile data, please visit Dr.Fone - Phone data recovery