Excel is a very useful program as companies and individuals use it to organize using tools, charts, tables, formulas, and various other tools. One can come across unexpected issues while using this program.
One of these issues is the file corruption error that occurs because of virus infections and other unknown reasons. If you are also bothered by a corrupted excel file on Windows 10, then below are the solutions that you can apply to fix Excel file corruption issues.
There is a chance that your file is malfunctioning because of a malware attack. In such a case, you must run a deep system scan using the antivirus software you have on your PC. This program will remove any viruses detected on the system and will allow you to open your file without any problem.
Carry out the steps mentioned below in order to use open and repair tool to fix Excel file corruption issues.
Step 1: First of all, launch the blank Excel document
Step 2: Launch File and then select Open.
Step 3: Choose corrupted files from the Open dialog box and then go to the drop-down menu and select "Open and Repair".
Carry out the steps mentioned below in order to restore the corrupted Excel file from the previous version.
Step 1: First of all, go to the Excel file and then right-click on it. After that, select Properties.
Step 2: Select Previous Versions and then select the latest version and then select Restore.
Follow the steps mentioned below to link external references to the corrupted workbook.
Step 1: Go to File and then select Open.
Step 2: Now, open the folder that contains the corrupted workbook. Now, right-click on the workbook.
Step 3: Now, click on Copy and then select Cancel.
Step 4: Choose File and then go to New. After that, open a Blank workbook.
Step 5: Go to the cell A1 of the workbook. After that, type =FileName!A1. Here, filename is the name of the corrupt workbook. Now, press Enter.
Step 6: Choose corrupted Excel if you see the Update Values box and then select OK.
Step 7: Now, you will see a select sheet dialog box on the screen. Select the appropriate sheet and then click on OK.
Step 8: Select cell A1and then click on Home and then finally select copy.
Step 9: Choose the area in the cell A1, which has the same size as the range of cells that have data in the corrupted workbook.
Step 10: Select Home and then click on Paste.
Step 11: Now, copy all selected cells by selecting Home and then click on Copy.
Step 12: Select Home, then paste and then finally click on Paste Values. This will remove all the links to corrupted Excel file. This will only leave you with the data.
Carry out the steps mentioned below in order to recover a TMP file.
Step 1: First of all, open File Explorer and then go to This PC.
Step 2: Go to the Users folder and the double-click on it. After that, launch the AppData or Default folder.
Step 3: Select Microsoft from the local folder.
Step 4: Search for the Office Folder and then select UnsavedFiles.
Step 5: After that, search for the temporary excel files starting with $ and ending with.TMP.
Step 6: Copy these files and save them in another location with .XLS extension.
DISCLAIMER : Windows Error is an independent Technical Support Provider. We are not affiliated to any 3rd party brand unless specified. Call vendor for direct Support.