Wednesday, November 23, 2022

How To Recover Corrupted Excel File in Windows 11

Just like any other Microsoft application, even Excel is not without its flaws. You are bound to run into software errors time and again without exception. Thankfully, it is not an impossible task to recover an excel file that has been corrupted due to software issues. There are three possible fixes to the problem.

Excel

1# RECOVER FROM TMP FILES

Recovery via TMP files is always the first step when faced with a corrupted Excel file you need to restore. While you are working on an Excel file, it automatically saves your file progress in case it crashes. In situations where it does crash, Excel’s built-in recovery system jumps into action and makes it easier to recover files. Firstly, you need to open the Microsoft Office folder that holds all of your temp files. For Windows 11, the files can be found here:

C:\Users\username\AppData\Local\Microsoft\Office\Unsaved Files\

In this, look for files whose file name starts with $ or ~. Additionally, the file extension needs to be TMP. Copy the TMP file you wish to restore. Paste it in a new folder and remember to change the extension from TMP to XLS. Now you can open this file and save it for future use.

Also read: Top 20 Shortcuts In MS Excel For Professionals

2# RECOVER CORRUPTED FILE FROM PREVIOUS VERSION

This technique has proven to be quite helpful. The Window’s Previous Version feature is a quick and efficient way to recover a corrupted Excel file. To start, open MS Excel and make a new spreadsheet. Save it with the same name as the corrupted file. Following this, right-click on the Excel file and select Properties. Now scroll down to the Previous Versions option and select the most recent copy available there and restore.

Also Read: How To Fix Low Microphone Volume Issues In Windows 11

Excel

3# RESTORE FILES USING RECOVERY SOFTWARE

Usually, the two above-mentioned methods yield desired results. But on the off chance that they don’t, you can use recovery software to restore corrupted files. There is multiple software available for this but we will focus on EaseUS Data Recovery Wizard. Softwares like this allow you to restore deleted, corrupted, and formatted Excel files. Your first step will be to download the software on your device.

Following that, choose the drive/folder which you believe contains your lost files and click Scan. To pace up the scanning process, click on Filter on top and select Excel or just search .xlx or .xlsx.

From the scanned options, double-click to preview the files. Now select the desired files and click Recover.

Though this was a simple process, you can end up finding yourself in confusion even after the file has been recovered. Like, the recovered file not opening. There are two possible ways to deal with this problem.

Firstly, open a blank new Excel sheet. Click on File and then Open. Look for and select the folder that has the corrupted file. Now in the Open menu choose the corrupted file. In the drop-down menu in Open, select Repair in Open and Repair. This should recover all your data but if it doesn’t and that is a very big if, click on Extract Data.

Another method to recover the corrupt file would be by saving it in an alternative format. Open the corrupted file, if possible, and click on Save As. Here, change the file format to Web Page. Save this file. Now find this newly saved file and open it using Excel. Additionally, if the file opens fully recovered, you can go to Save As again and change the format back to .xls or .xlsx.

On a side note, when changing the format back to .xls or .xlsx, change the file name as well so that you don’t confuse it with the corrupted file which still might be on your device.

Sometimes, you might also find yourself in a situation where you need to recover data from a corrupted Excel file.

In such a situation, if the corrupted file can be opened, Select All Sheets by right-clicking on a sheet tab. Now copy Excel sheet tabs. Create a New Book and choose to Create a Copy Box.

In case you can’t open the Excel sheet, change the calculation settings from Automatic to Manual. This will help open the corrupt file.

Hopefully, this guide was able to give you effective solutions for recovering a corrupted file in Windows 11.

Using Google Docs to Open a Corrupt...
Using Google Docs to Open a Corrupted Microsoft Excel File

Popular

- Advertisement -

Latest

Related articles

Reset Mac Pro

How To Reset Macbook Pro

0
You'll have to reset your Mac pro after using it for a while. There may...
remove auto highlighting

macOS Ventura: How To Remove Auto Highlighting On Spotlight Results

0
Assume you use your Mac for both professional and personal reasons daily. In that case,...
OS Ventura Not Detecting 4k Display

OS Ventura Not Detecting 4k Display: Issue Fixed

0
After upgrading to macOS Monterey 12.3 and 12.4, as well as macOS Ventura, Big Sur,...
Apple Emergency SOS via Satellite

How To Set Up And Use Apple Emergency SOS Via Satellite?

0
It was evident when Steve Jobs unveiled the iPhone in 2008 that Apple's central mission...
Can't Update Macbook Pro 2018 Big Sur To Ventura

Can’t Update Macbook Pro 2018 Big Sur To Ventura (Solved)

0
New to macOS Ventura, the newest version of macOS 13, are enhancements such as Live...
SMB File Sharing Not Working In Ventura

SMB File Sharing Not Working In Ventura (Fixed)

0
Apple's macOS was the first operating system to have file-sharing capability. It may be found...
How To Add Ventura Weather App To Finder Bar

How To Add Ventura Weather App To Finder Bar?

0
You must always keep a potent weather app on your radar so you never get...
macOS Ventura: Dictation Not Working After Upgrading

macOS Ventura: Dictation Not Working After Upgrading

0
Mac users, prepare for macOS Ventura, Apple's next operating system. There were several new additions...
Ventura update prevents zoom

macOS Ventura Update Prevents Zoom From Operating: Solved

0
You have Zoom up and running on your Mac, but you cannot attend any meetings...

macOS Ventura: External Display Resolution Issue (Fixed)

0
After updating to macOS Monterey 12.3 and 12.4, as well as macOS Ventura, Monterey, Big...

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.