For office workers, especially those who work in accounting, it is inevitable that there are file errors in the process of using Excel. Although you are very careful, but for many different reasons, such as a computer infection, or due to the backup process, faulty copying will lead to this situation.
This is really bad if the file is unique and you do not have any backup. So in this case what will you do to recover this corrupted excel file?
Although it is not certain that it will be 100% successful in all cases, in this article I will share with you some tips I have collected and in general the success rate is quite high. Okay! If you are having an error that the excel file or word cannot open or has an error, you can apply some of the methods below.
I. Guide to most effectively fix Excel and Word files
Yes, and here are 7 ways that I know, in addition to the ways I presented below, if you have any other options, do not forget to share again in the Comment section below. Thank you!
Option 1: Try to copy the corrupted Excel file on another computer
First, to determine if your Excel file is correct or not, you can test copy the Excel file to another computer to test it.
Or if you have a bootable usb or a virtual computer, you can test it on it. If the Excel file is definitely faulty then move on to step 2 to start fixing.
Method 2: Open the corrupted Excel file with a newer version
If you are using Office 2003 or Office 2007, you can copy it to other computers and open it with a newer version such as Office 2010, 2013 or Office 2016.
Method 3: Repair Excel, Word file when it fails
Instructions are done on Word 2013, other Word versions you do completely similar!
+ Step 1: Open a new Excel file => then click File => Open => select Computer => click Browse and navigate to the corrupted Excel file you want to fix.
Tips: Word 2010 is similar to 2013, while Word 2007 is a little different in interface, you can click the Office button in the top left corner> then also find the Excel file that is having errors.
+ Step 2: After pressing 1 to play the corrupted Excel file, then click on the drop-down arrow next to the word Open as shown below.
Now choose the Open and Repair feature to open and repair.
A popup message appears, choose Repair for the program to proceed to fix the error.
Okey! Now open the corrupted Excel file to see if it is okay
ncG1vNJzZmismaXArq3KnmWcp51ksLC%2B0a6nrZ2UYrK5r8SlZJ%2BhnJp6orrDZquhnV2ivLTAjJ6dn52Tqba3sYywmLJlpKR6s7HCqK2eql2axaSxy2adoqSVqA%3D%3D