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

Maximize Value from Microsoft Defender

In this ebook, you’ll learn why Red Canary’s platform and expertise bring you the highest possible value from your Microsoft Defender for Endpoint investment, deployment, or migration.

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”

Leave a Reply

External Sharing and Guest User Access in Microsoft 365 and Teams

This eBook will dive into policy considerations you need to make when creating and managing guest user access to your Teams network, as well as the different layers of guest access and the common challenges that accompany a more complicated Microsoft 365 infrastructure.

You will learn:

  • Who should be allowed to be invited as a guest?
  • What type of guests should be able to access files in SharePoint and OneDrive?
  • How should guests be offboarded?
  • How should you determine who has access to sensitive information in your environment?

Sponsored by: