How to Fix Unreadable Excle Files?

Solution: Excel electronic report software is one of the most widely used software, its data processing, chart functions and various functions and tools are deeply loved by the majority of users. The file of excel is a workbook, and a workbook can contain 255 worksheets, and each worksheet can contain a large amount of data.

What should I do if an excel file is a little corrupted and doesn't open properly?

Method 1: Handle it manually.

1. Go to Word, in the "File Open File Type", select "All Files", and specify the one you want to repair. XLS file, after opening, if excel has only one worksheet, it will be automatically loaded into word in the form of **, if the file is composed of multiple worksheets, only one worksheet can be opened at a time.

2. Delete the corrupted part of the file.

3. Select ** with the mouse, select "** to text" in the "**" menu, and you can choose to use "," separator or other separators.

4. Save it as a text file. txt。

5. Open the text file directly in Excel and save it as an Excel file with other names.

Note: This repair method is to use the function of Word to read excel file directly, this method is more effective when the file header is not corrupted, but the file content is corrupted, if the file header has been corrupted when the excel file, this method may not be successful, you must resort to other methods.

Method 2: Use Excel Repair Tool.

Concept Data offers a repair tool dedicated to repairing Excel corrupt files, ExcelRecovery.

**After the software is installed, you can automatically install the Excel repair program in the Excel application, under the file menu, there is an additional recovery option, if there are corrupted files, you can use this option to repair. Here's how to use it:

1. Open Excel.

2. Click the "Recover" option in the "File" menu, and the dialog box of Excel Recovery will open.

3. Specify the Excel file you want to repair, and then press the [recover] button.

4. Automatic repair, you need to wait for a while.

5. The repaired file will be opened.

6. Save as a new file name to complete the file repair work.

Note: This version can only fix normal files, not Excel files with Visual Basic**, charts, and passwords, if you need to fix these files, please register. It should be noted that the files saved in the floppy disk are very easy to be damaged, and can be repaired by the above methods after corruption, but if the disk where the files are saved has zero track damage or cannot read and write correctly, etc., it is necessary to repair the disk and files first, and then use the above methods to repair the excel file.

There are many ways to repair files, and if it is a Word file, there is also a tool that specializes in repairing Word files.

Method. 1. Manually repair the damaged workbook.

For workbooks that are corrupted due to program failure, users can manually restore them, mainly in the Open dialog box, as follows:

Steps. 1. Start the Excel2010 program, click the "Open" button in the "File" tab to open the "Open" dialog box, select the workbook that needs to be repaired, click the drop-down button on the right side of the "Open" button, and select the "Open and Repair" command in the pop-up drop-down menu, as shown in the figure:

<> will open the "Fix to [workbook name].xlsx dialog box, click the Close button to open and repair the selected workbook. If you click the hyperlink in the Click to View Repair Records column, you can view the detailed repair information, as shown in the image

Method. 2. Automatically repair the workbook damaged due to program failure.

Excel has the function of automatically repairing workbooks damaged by program failures, and when opening the damaged workbook, EXCCL will automatically start the "File Recovery" mode to reopen and repair the work.

On the left side of the open workbook operation interface, the "Document Recovery" pane is displayed, which lists all the workbooks that have been closed due to program failure, move the mouse cursor to the corresponding workbook, click the button on the right, select the "Show Repair" command in the pop-up drop-down menu to display the content of automatic repair, and select the "Open" command to open the workbook, as shown in the figure:

Skill Dial: Repair data corruption workbook.

If the data of the workbook is corrupted, a prompt message will pop up when you open the workbook, prompting the workbook to find unreadable content, click the "Yes" button in the prompt dialog box, the "Repair to [workbook name] xlsx dialog box will open, which means that the workbook has been repaired and the unreadable data will be deleted, click the "Close" button to open the repaired file.

If you want to enable the document recovery function, you can click the "Options" button in the "File" tab to open the "Excel Options" dialog box, and in the "Save" tab, uncheck the "Disable only automatic recovery of this workbook" check box.

Excel files are usually supported in the format (so-and-so. xls) which is a file that supports opening.

Let's see if the file extension name is changed automatically, and if so, you try to change it back to see if you can!

Try the USB flash drive to disinfect the virus.

The specifics are not too clear. However, you can try to open it in safe mode with Word.

The cause of the failure.

Hyperlinks form links to external documents.

Copy data from other documents, reference other document data, and form external data references in formulas.

Macros specified by graphics, buttons, and so on point to macros in external documents.

The cause of the problem and how to fix it.

We open the excel file and the prompt described above appears and we find something unreadable.

I clicked Yes, and by fixing or deleting the unreadable content, excel has been able to open the file, and below is the row and line of errors.

Although the problem has been fixed automatically, it is still necessary to figure out the cause and carefully look at the part of this dialog box marked in red.

There is a problem with the file in the xl folder.

Change the extension of the xlsx file to a zip archive.

Double-click the zip file, open it and see, note, this is not unzipping, open the file, the browser will automatically pop up, and the xml web page cannot be displayed.

It turned out to be shown in red"si"with"t"There is an error in the tag, we look at the source **, as shown in the figure below, step 2 prompts the number of wrong lines, then we will see if the error is **.

Those who understand XML can see at a glance, and if they don't understand, listen to me. The syntax rules of XML files are that each tag must have an open tag (e.g., ..).and off labels (e.g. ....The second is that these tags must be properly nested. Modify the source to look like the following image.

Save, then change the extension to xlsx, and you're done.

The above is the solution to the content that cannot be read when the excel file cannot be opened. Store files in excel files with care, and check the security of the system in time! So after reading the above content, netizens no longer have to worry about not being able to open the excel file!

Change your computer!

Do it all over again, and an afternoon's work will be in vain, and the ...... will collapse

Finally, I found the following wonderful solution on the Internet, record it for next use:

1. When you open Excel, "...... pops upFound unreadable content, do you want to recover the contents of this workbook? ......Dialog box;

2. Click "Yes", and "Excel has been able to open the file by repairing or deleting the unreadable content" will pop up. dialog box and shows where the file went wrong;

3. Now that we know the location of the error, the next step is to find the error file and correct it, first put the extension of the excel file (..)xlsx) to a compressed file (.).zip）；

4. Double-click to open the zip file, find the file under the XL folder and double-click to open the file (generally open in IE browser), the error reason will be displayed on IE browser;

5. Right-click on the page and click "View Source File", the source window will pop up (usually opened by Notepad), find out the error according to the prompts in Figure 2 and Figure 5, and correct it according to the syntax rules of the XML file (in this example, "7, click on the compressed package just opened under the taskbar, and it will prompt that "the file has been modified. Do you want to update it in a zip file? ”，

The solutions to excel file unreadable and unrepairable are as follows:1Make a copy of this file and rename it. zip file.

Then open the file, and then open the XL folder.

You'll see a file with a file name.

Drag the file to your desktop.

2.Double-click to open this file, pull the scroll bar to the bottom, there is a prompt in the following figure, indicating that there is an abnormality in the table, which is generally missing (my personal experience) and occasionally missing.

3.Open with emeditor.

4.You will see the following picture, the red label indicates that it appears in pairs, and one less will make an error, they are a whole.

7., one less, in the position below (this is found from below), don't forget that it appears in pairs, select one, this one is grayed out as a whole.

8.Add the missing ones in.

9.The changed one will be replaced with the original.

10.Rename this file to the original image below. xlsx format.

11.Open it as shown below, and you're done.

Either it's poisoned, or it's really broken. If you are poisoned, use anti-virus software and anti-macro software to kill it.

Maybe the document is damaged, I also had one a few days ago, and then I changed to a new computer, only to know that the document is too big, and part of the content is damaged.

Check if there is a macro virus.

If the cups haven't been backed up, I'm afraid they'll have to start over.

If you have the original file before you repaired it, there is still hope, otherwise, you have already modified it, and there is nothing you can do.

You can go to the path of the excel recovery file to see if there is one, and the format is *xar or something.

Or try some data recovery software! However, it is best not to keep reading and writing files such as excel documents before this, otherwise the data will be overwritten.

Run Excel from Start-Program to see if there is anything on the left that can be recovered.

Back up a copy first, then test it. Generally speaking, there is no solution to such a situation.

If your current excel program is wrong, you still need to install your excel program from scratch.