Home > Data Recovery due to Application Errors > Microsoft Excel Workbook Corruption

Recover From Microsoft Excel Workbook Corruption

Observations

Microsoft Excel workbook files do not open correctly. You may receive the following error message:

Cannot find the file or one of its components. Make sure the path and filenames are correct and that all required libraries are available.

Possible Causes

The workbook files are corrupted.

Resolution

These are several methods to recovering corrupted Excel files.

Backup the copy before attempting the recovery

• Click Start, select Programs, select Microsoft Office, select Microsoft Office Tools, and then select Microsoft Office Application Recovery
• In the Application list, click Microsoft Excel, and then click Recover Application
  
  
  
  

Use the "Open and Repair" Command

This method is the primary method of file recovery in Excel 2002 and later versions. To do this, follow these steps:

• Start Excel
• Under File menu, select Open
• In the Open dialog box, select the file that you want to open.
  
  Click the arrow on the Open button, select Open and Repair
  
  
• When you are prompted, click Repair to recover your most recent changes
• Finally save your recovered workbook

Open the File in Word or WordPad

This method does not recover any module sheets, dialog sheets, chart sheets, macro sheets, or any embedded charts and only the results of those formulas that are currently in the cells. To do this, follow these steps:

• Open Microsoft Word or WordPad
• On the File menu, click Open
• Under Files Of Types, select All Documents or All Files
• Browse and select the corrupted excel file

More Information

This article only applies to:

Microsoft Excel 2002

Microsoft Excel 2003

DATA RECOVERY DUE TO APPLICATION ERRORS
	Solutions to common application problems
Mail Recovery Locate Outlook Express Store Folder Microsoft Outlook Express Crash Microsoft Outlook Express Startup Error Microsoft Outlook PST Corruption Prevent DBX File Corruption Repair DBX File Corruption Microsoft Office Data Recovery Microsoft Office Startup Error Microsoft Access Database Corruption Microsoft Powerpoint Slide Corruption Prevent Microsoft Powerpoint Corruption Microsoft Word Startup Error Microsoft Word Document Corruption Microsoft Excel Startup Error Microsoft Excel Workbook Corruption
DATA RECOVERY RESOURCES
	Do-it-yourself troubleshooting tips and knowledge on storage media types.
Data Storage Media Understanding the Operating System and File System Data Loss Situation and Recovery Data Recovery First Aid Hard Disk Data Recovery Data Recovery due to Application Errors Mobile Phone Data Recovery System & Data Backup Other Articles on Data Storage
SERVICES
	ADRC provides data recovery services for a wide range of storage media.
Hard Disk Recovery File Recovery Database Recovery Iomega Disk Recovery Mail Recovery Optical CD Recovery RAID Disk Recovery Others Forensic Investigation