Learn What IT Pros Need to Know About Windows 11 - August 24th at 1 PM ET! Learn What IT Pros Need to Know About Windows 11 - August 24th at 1 PM ET!
Office

Repair Corrupt Microsoft Excel Spreadsheets

How many times have you been working away on a complex spreadsheet only to have Excel crash? Often you’re left with a corrupt spreadsheet you can’t open and critical data you can’t access.

This guide outlines how to use Stellar Phoenix’s Excel Recovery application to automatically repair your damaged .XLS or .XLSX files and recover Excel worksheets, formulas and formatting.

Note: For .xls password recovery go here: Recover an Excel Password

Step 1: Download and Install the Excel Spreadsheet Recovery Utility

To perform the following recovery steps, you’ll need to download and install Excel Recovery from Stellar Phoenix, download available directly here. (3.5Mb)

Sponsored Content

Read the Best Personal and Business Tech without Ads

Staying updated on what is happening in the technology sector is important to your career and your personal life but ads can make reading news, distracting. With Thurrott Premium, you can enjoy the best coverage in tech without the annoying ads.

Once you’ve downloaded the program, run the install with the default options.

Step 2: Locate the Damaged File and Begin the Recovery Process

Open Stellar Phoenix Excel Recovery from the icon on your desktop.

icon

On the top left, click the Add File to Tree View button and navigate to the damaged spreadsheet file. To make it easier, the browsing window automatically filters for XLS and XLSX files.

excel-recovery-00151

Select the Open button to add the file location into the wizard.

In the list that appears on the left, select the checkbox beside the file you’d like recover.

excel-recovery-0017

3. Preview the Recovered Excel Data

A handy feature of Excel Recovery is its ability to give you a preview of your recoverable data, even down to the individual worksheets, before beginning the restore process. Simply double click the file to launch the preview.

excel-recovery-0019

4. Restore Your Spreadsheet

To proceed with the recovery, select ‘Start Repair’ from the toolbar or ‘File’ menu.

In the ‘Advanced Options’ dialogue, choose where you’d like the recovered Excel file to be saved.

Note: For quick access afterward, you’re able to choose a custom location like your ‘Desktop’ as the destination.

excel-recovery-00211

Select ‘OK’

The recovery utility will now run through and repair and restore your corrupt file. As it does, you’ll see its progress in the bottom half of the application window.

Once complete, a final dialogue will appear indicating success.

excel-recovery-0023

That’s it! Your file is now fully recovered and waiting for you in the location you specified.

Final Notes

In our run through, we repaired a single Excel file, but the app also includes the functionality to recover  multiple files at once (a handy feature for high volume users).

Stellar Phoenix Excel Recovery software supports the latest versions of Microsoft Excel including Excel 2007, Excel 2003, Excel XP, Excel 2000 and is compatible with  Windows Vista / XP / NT/ 2003/ 2000.

Related Topics:

BECOME A PETRI MEMBER:

Don't have a login but want to join the conversation? Sign up for a Petri Account

Register
Comments (1)

One response to “Repair Corrupt Microsoft Excel Spreadsheets”

  1. Corrupt xls | Mountbattenwin

    [...] Excel Recovery – How to Repair Corrupt Excel, .xls SpreadsheetsJan 21, 2009 … This guide outlines how to automatically repair your damaged XLS or XLSX files and recover Excel spreadsheets, tables, formulas and … [...]

Leave a Reply

Register for Advanced Microsoft 365 Day!

GET-IT: Advanced Microsoft 365 1-Day Virtual Conference - Live August 24th!

Join us on Tuesday, August 24th and hear from Microsoft MVPs and industry experts about how to take advantage of Microsoft 365 at a technical level and dive deep into the features and functionality that will make your environment more secure and compliant.

RSVP Now

Sponsored By