Recovery of corrupted Excel 2010 files is essential if your important data cannot be opened and there are no backups. This article will guide Taimienphi.vn you how to recover corrupted Excel 2010 files?
Excel 2010 is a spreadsheet program that is used a lot with offices today, but it is inevitable that errors will occur during use. So how to recover corrupted Excel 2010 file?
Instructions on how to recover corrupted Excel 2010 data
With Excel, the calculation job becomes much simpler, there are many calculation functions supported by Excel that make operations very concise. With the sum function in Excel we can use Sum. Calculation of use Sum function will save you a lot of time with ordinary mathematical additions.
If your calculations are conditional, you can use the SumIF function. In Excel to use SumIF function known with conditional sum function to help you calculate more accurately and quickly. And below, let’s find out the corrupted Excel 2010 file recovery with Taimienphi.vn.
Table of Contents:
1. Restore manually.
2. Turn off the Automatic Calculation Mode.
3. Use Microsoft Office Tools.
Recover corrupted Excel 2010 file
First you need to have Excel 2010 in the device, if you do not have it, you can download it here:
Download Excel 2010: Download Excel 2010.
In the process of using Excel your data file suddenly shows signs of being unable to open, displaying strange characters, we have the following types of recovery:
1. Restore manually
Step 1: Click File and select Open (Press the keyboard shortcut Ctrl + O to do this).
Step 2: Select the path containing the corrupted Excel file, click Select. Here in the Open section, select the dropdown, and select Open & Repair.
Step 3: The screen will appear a message, you select Repair to repair the file
Step 4: If Repair has not been, you can choose Extract Data to recover data.
So we can recover the file manually.
2. Turn off the Automatic Calculation Mode
Step 1: Click the File tab in the program interface and select Options
Step 2: Immediately the screen will appear setting table, Select Formulas tab.
Step 3: Here, select the Manual entry in the Calculation Options section.
Then click OK to confirm.
3. Use Microsoft Office Tools
Step 1: Open StarMenu and select All Programs.
Step 2: Search the Microsoft Office folder. And choose the Microsoft Office folder.
Step 3: Select the Microsoft Office Application Recovery program.
Step 4: The program will appear on the screen, select Excel and click Recovery Application.
Immediately the Excel program will be shut down and restarted, the spreadsheets will appear, there may be attached Excel files that you have errors. Click to use.
So we have restored Excel 2010 file with 3 ways that Taimienphi.vn mentioned above, you can choose 1 of 3 ways to handle this problem. With Excel spreadsheets that use monetary data, you can use the trick to convert numbers into words quickly. Tips convert numbers to letters will help you automatically convert cash numbers into words in a convenient way.
Also during the data entry process, you cannot avoid having duplicate data. To solve this problem, you can follow the steps in the article Duplicate data filtering to erase these redundant data quickly.