Instructions on how to recover corrupted Excel 2010 files


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).

Error asking excel 2010 file

Step 2: Select the path containing the corrupted Excel file, click Select. Here in the Open section, select the dropdown, and select Open & Repair.

Error asking excel 2010 file

Step 3: The screen will appear a message, you select Repair to repair the file

Error asking excel 2010 file

Step 4: If Repair has not been, you can choose Extract Data to recover data.

Error asking excel 2010 file

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

Error asking excel 2010 file

Step 2: Immediately the screen will appear setting table, Select Formulas tab.

Error asking excel 2010 file

Step 3: Here, select the Manual entry in the Calculation Options section.

Error asking excel 2010 file

Then click OK to confirm.

3. Use Microsoft Office Tools

Step 1: Open StarMenu and select All Programs.

Error asking excel 2010 file

Step 2: Search the Microsoft Office folder. And choose the Microsoft Office folder.

Error asking excel 2010 file

Step 3: Select the Microsoft Office Application Recovery program.

Error asking excel 2010 file

Step 4: The program will appear on the screen, select Excel and click Recovery Application.

Error asking excel 2010 file

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.

https://thuthuat.taimienphi.vn/phuc-hoi-file-excel-2010-bi-loi-7519n.aspx
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.

.

Add a Comment

Your email address will not be published. Required fields are marked *