• A corrupted Excel file can result in a lot of wasted time and severe data loss.
  • Fortunately, there are ways to fix damaged files even if you did not back up your information aforehand.
  • We know how important it is to be able to act quickly and rely on both native and third-party tools.
  • So, here’s an in-depth guide on how to recover corrupted Excel files in Windows 10.

how to, microsoft, windows, microsoft

XINSTALL BY CLICKING THE DOWNLOAD FILE

Excel is a crucial program used both by individuals and businesses to work with large amounts of data and organize it using formulas, tables, charts, and several other tools.

However, while using the program, you can encounter different unexpected problems, one of them being file corruption errors due to the system, virus infections, or other unknown reasons.

How can I repair a corrupted Excel file?

If you face this situation, you can find below several possible solutions that can help you solve the problem.

1. Check your computer for malware to repair Excel files

It is very likely that your document could malfunction due to a virus attack. In this case, it might be a good idea to run a deep systems scan using the software you have on your computer.

The program should eliminate any viruses found and you should be able to open the document. If you are looking for a security tool, you will be happy to know that some of the best antivirus software have free trial versions.

If you are not completely sure which one would be best for your own needs, you can try out a few.

The most important thing to look for in antivirus is its threat database. Along with that, make sure that the security tool of your choice has multi-layered protection. This ensures that you are protected on all fronts.

Additional requirements any antivirus should check are a transparent privacy policy, low resource usage, and non-intrusive notifications.

Once you decide on the antivirus program and install it, run a full PC scan and remove/quarantine all threats found.

2. Use third-party software to recover corrupted Excel files

Another possibility is to use professional data recovery software that can fix corrupted Excel documents.

Data recovery software scans your whole device for lost or corrupt files. They typically offer an overview of everything they can find and let you know which files can be restored.

When it comes to Excel documents, dedicated software is able to detect and eliminate the cause of corruption, thus allowing you to open your spreadsheets without any issue.

These tools are very powerful and they come with additional recovery features that can help you restore full lost disks and lost files on removable media.

3. Use the Open and Repair tool to fix the Excel file

  1. Open a blank Excel document.
  2. Go to File and click Open.
  3. In the Open dialog box, select the corrupted file and then click on the drop-down menu next to Open to select Open and Repair
    how to, microsoft, windows, microsoft

Note: To recover as much of the workbook data as possible, pick Repair. If Repair is not able to recover your data, pick Extract Data to extract values and formulas from the workbook.

4. Restore the corrupted Excel file to a previous version

  1. Right-click on the Excel file and select Properties
  2. Go to Previous Versions, find and select the latest version or the right version before Excel crashes, deleted or saved, and click Restore
    how to, microsoft, windows, microsoft

Note: The workbook opens without any changes you made that might have caused the workbook to become corrupted.

5. Recover corrupt Excel files by changing the calculation method

A corrupted Excel file could be accessed by changing the Workbook calculation method to be manual.

This calculation is set to be automatic by default, which means the Workbook is calculated every time you try to open a file. Turning this off can help fix the error and allow you to open the corrupt Excel file.

1. Open Microsoft Excel.

2. Click on File and choose New.

3. Click Blank workbook under New.

4. Navigate to File and go to Options.

5. Click Manual under Calculation options in Formulas category.

6. Press OK to apply and save the changes.

7. Try to open the previously corrupted Excel file.

6. Use external references to link to the corrupted workbook

  1. Click File and go to Open
  2. Go to the folder that contains the corrupted workbook and right-click on it.
  3. Click Copy, and then click Cancel.
  4. Click File and go to New, then open a Blank workbook.
  5. In cell A1 of the new workbook, type =File Name!A1, where FileName is the name of the corrupted workbook that you copied in step 3 (without the name extension), and then press Enter.
  6. Select corrupted Excel if the Update Values box appears and click OK.
  7. Choose the appropriate sheet if the Select Sheet dialog box appears and click OK.
  8. Select cell A1 and click Home and then Copy.
  9. Select an area, starting in cell A1 that is approximately the same size as the range of cells that contain data in the corrupted workbook.
  10. Click Home and Paste.
  11. Repeat to copy all selected cells again by clicking Home and then Copy.
  12. Click Home go to Paste and click Paste Values under Values.
    how to, microsoft, windows, microsoft

Note: Pasting values will remove the links to corrupted excel and leave you only with the data by then.

By using the method, you won’t be able to recover formulas, formats, charts, macros, and so on, but recovering the data is better than recovering nothing.

7. Recover the TMP file to repair the corrupted Excel file

  1. In File Explorer, open This PC (usually C: )
  2. Double click the Users folder and then open the Default and AppData folder. (Make sure you can view hidden files.)
  3. In the Local folder, go to Microsoft.
    how to, microsoft, windows, microsoft
  4. Locate the Office folder and then go to UnsavedFiles.
  5. Locate and find the temporary excel files beginning with $ or ~ and end with .TMP
  6. Copy these files and save them to another safe spot by changing the extension from.TMP to .XLS/.XLSX

8. Delete the TEMP folder to fix corrupted files in Excel

If saving a temporary excel file did not work, another suggestion is to delete some of the temporary files and folders on your computer.

These files and folders can be found in C:/Windows/temp directory. Once you have deleted these files, restart your computer and then try opening the Excel document again.

If you can’t delete temporary files, use our guide to fix the problem.

9. Save the corrupted Excel file in HTML format to try to repair it

  1. Open the Excel file and go to Save As.
  2. Choose other formats from the drop-down menu in the Save As Type option.
  3. Then select Web Page.
  4. Make sure entire Workbook is selected and then click on Save
    how to, microsoft, windows, microsoft
  5. Right-click on the web file and choose Open with Microsoft Office Excel.
  6. Once the document is open, go to Save As again and choose the Excel format.
  7. Choose a different name than the original corrupted file and press Save.

10. Save the corrupted file in SYLK format to recover it

  1. Open the Excel file and go to Save As
  2. Choose other formats from the drop-down menu in the Save As Type option
  3. From the options in the drop-down list, select SYLK(Symbolic Link) (*.slk)
    how to, microsoft, windows, microsoft
  4. Click File and Open again, but this time choose the SYLK file.
  5. Once the file is open, click File and then Save As.
  6. Choose Microsoft Excel Workbook and click Save.

Note: Using the SYLK format only saves the active worksheet. You will have to save each worksheet individually and repeat this procedure.

11. Recover the corrupted Excel file by opening it in WordPad or Word

how to, microsoft, windows, microsoft

Another solution that we recommend is to try opening your corrupt file in WordPad. If it works, WordPad will convert everything to text but unfortunately, this method will not recover formulas.

On the other hand, the good news is that, unlike many other data recovery methods, WordPad will recover your macros.

Simply search the recovered text for Sub and Function to find them. You might also be able to open the corrupted .xls file in Word, but the results will be limited.

In order to do so, you first have to make sure you have the Microsoft Excel Converter installed. You can download it from Microsoft’s official page.

12. Use the XML format to open and recover the corrupted Excel file

  1. Open the corrupted file, go to File and click on Save As.
  2. From the list of possible formats next to Save as Type select XML Spreadsheet and then click Save.
  3. Open the document again.
  4. Go to Save As again and then save the document as an Excel Workbook by choosing Excel format from the drop-down list next to Save as Type.
Read more about this topic

  • Download Phoenix Browser for Windows 10 & 11 [32/64 bit]
  • Microsoft Sidewinder Precision Racing Wheel Drivers for Windows 10
  • 4 ways to batch rename files in Windows 10/11
  • How to easily install graphics card drivers on Windows 10

13. Open the Excel file in Safe Mode to remove corruption signs

  1. Press Windows+R keys to open the Run dialogue window
  2. Type the command excel /safe and click OK
  3. Copy all of the data to a new document and open it in Normal Mode.

This method may disable your macros and Add-ins but it is a great solution because you can move the data to a new document.

14 Use newer Excel versions to try to recover a corrupter file

Although it seems like a very simple solution, you should definitely try it as well.

Try to use a later Excel version because as the versions increase, the ability for the program to recover a file increases also, so you might be able to recover your file using this simple method.

So, have any of these solutions helped you to fix your corrupted Excel file? Let us know in the comments section below.

TECH NEWS RELATED

Overwatch 2: How to Ping on Console and PC

Overwatch 2 introduces a new ping system that allows you to communicate enemy locations to your teammates instantaneously. Here's how to use it.

View more: Overwatch 2: How to Ping on Console and PC

How to get every Phantasma Prime Relic in Warframe

Screenshot by Gamepur Prime weapons require some grind and a little luck to track down the parts needed to build them. Phantasma Prime is no different in this regard. Void relics can be acquired in numerous ways, and you need to track down specific ones to have a chance ...

View more: How to get every Phantasma Prime Relic in Warframe

This Total War: Warhammer 3 mod kicks off the skeleton war

A Total War: Warhammer 3 mod called Necromancy lets you recruit units killed in battle, bringing them back as skeletons who will fight in the skeleton war

View more: This Total War: Warhammer 3 mod kicks off the skeleton war

Here are the changes to Canadian mobile rate plans this week [October 6 – October 12]

With over 13 wireless providers in Canada, it can be difficult to keep track of the latest promotions and cell phone rate plan changes.  MobileSyrup will compile the latest weekly rate plan deals every week. You can also check out our guide on plans across Canada to find the ...

View more: Here are the changes to Canadian mobile rate plans this week [October 6 – October 12]

Genshin Impact: Xiphos’ Moonlight – how to get it, stats, and ascension materials

Image via HoYoverse The Xiphos’ Moonlight is a 4-star Sword weapon added in Genshin Impact Version 3.1. This support weapon empowers characters who scale off of Elemental Mastery, giving your team a huge boost in Energy Recharge. This great weapon will make a great fit for any of your ...

View more: Genshin Impact: Xiphos’ Moonlight – how to get it, stats, and ascension materials

How to download software to download to your computer for faster download

If you want to download files faster, you can try the ways to download download software to your computer that GhienCongList introduces to you. Downloading a certain file on the Internet usually has a slow download speed and can be corrupted at any time, that’s why users should think about ...

View more: How to download software to download to your computer for faster download

Bored Ape Yacht Club Community Council Formed by Yuga Labs

Seven holders of the coveted Ethereum NFTs have been appointed to serve, but not everyone is pleased.

View more: Bored Ape Yacht Club Community Council Formed by Yuga Labs

Learn cooling technology on LG air conditioners

LG is a line of air conditioners that users trust in addition to owning a beautiful design. LG air conditioner also has the ability to cool quickly thanks to the application of modern cooling technologies. Let’s learn the application of cooling technologies on LG air conditioners with HC electronics. Jet ...

View more: Learn cooling technology on LG air conditioners

No fix in sight for mile-wide loophole plaguing a key Windows defense for years

The best Tatsu Prime build in Warframe

What does Client Requested Disconnect mean in Overwatch 2?

Apple Releases Safari Technology Preview 155 With Bug Fixes and Performance Improvements

Five Apple Products You Should Avoid Buying Right Now

Airoheart – how to access the full map

How to watch Hellraiser online: Where to stream, release date, plot and trailer

How to Mute Someone on Instagram

WearOS Phone app for Pixel Watch already available as a downloadable APK

How to recover permanently deleted files on Windows quickly

CPU upgrade – how to install your new processor

How to earn Mother Tokens in Warframe

OTHER TECH NEWS

Top Car News Car News