How to Repair Corrupt Excel File Error in Excel 2013?

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

What is the Error that causes Excel File to get Corrupted?

The cause of the error is usually due to:

  • a). some error in any add-ins in the third-party software.
  • b). If a string is added to a cell instead of a number this error may come. This can also happen if a string is added which is convertible to a number.

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

  1. Improper shutdown of the system: Many times computer systems 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 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, which is 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 an Excel sheet or improper closing of an opened file can be a cause of a corrupted Excel file.
  5. Large data size: 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 files to contain a large amount of data.
  6. Software conflict: Sometimes software conflicts as well as, rarely, though, printing excel files may also be the cause of damaged excel files.
  7. Macros and Formulas: Excel Macros and complex formulas also have a known bad reputation for creating corrupted data in a working worksheet.

With 'Open and Repair' feature to Repair corrupt Excel file

To repair the 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 to 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 files.

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

2. Restore (from the 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, an arrow near the recovered file may be clicked, and the '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 the "Open and Repair" feature. Follow these steps.

  • Open Excel
  • Click File -> Open.
  • Browse. Select a corrupted worksheet.
  • From the pull-down menu (pressing the arrow of the Open button) click 'Open and Repair'.

5.Third-party Tools.

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

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 files. This excel file repair software offers two licensed versions, one for a single user and another for multiple systems that are available supporting Mac (Excel2011) and all versions of windows.

Microsoft Excel Repair Tool

  • Repairs all kinds of data stored in damaged excel files 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 kinds 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 to repair corrupt excel files.
  • All kinds 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 Excel File Repair

For Windows, the following sequence of steps may be followed to easily repair corrupted excel files, 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 files.

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

Tips to Repair Corrupted Excel File

Case 1. When Excel cannot open the file

  1. Copy and open corrupt files on a 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 to open the 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 an Excel file.
  6. Decrease the size of the Excel file
  7. Go back to the last version of the file saved.

Precautionary Tips to avoid excel files get corrupted

  • Ensure the system is shut down properly.
  • Always install the latest anti-virus.
  • No bad sectors should be there on the storage device.
  • Always close Excel properly.
  • Avoid huge data handling with Excel.

Other popular Articles From Wondershare