How to Repair Corrupted Excel Files

The problem of Excel tables being damaged and unable to be opened also gives many people a headache. In many cases, they may have to redo the table. So what should we do if our Excel table is damaged? Aren’t all previous efforts lost in vain? Oh, NO! Below, the editor will share with you tips on how to repair damaged Excel files.

Excel documents give us too much convenience at work. Many users are even used to using Excel to create files when processing tables. It can be said that Excel is one of the indispensable software for office, but it will also If you hit a wall, for example, "The file is damaged and cannot be opened" appears when opening Excel. Below, the editor will explain to you how to repair damaged Excel files.

How to repair a damaged Excel file

Method 1:

When opening the file in excel2016, it prompts "The file is damaged and cannot be opened". Click the OK button to enter Blank program interface.

Excel Figure-1

Click the file button in the upper left corner of the blank program

Excel Figure-2

Click the option in the File menu

Table Figure-3

Select "Trust Center" → "Trust Center Settings" in the options

File Damage Picture-4

Select Protected View in the Trust Center Settings sidebar, uncheck (uncheck) the three checkboxes shown in the figure below, and click the OK button. , reopen it, and you can use it normally

##Table Figure-5

Method 2 (Add a trusted location )

Enter excel2016----Options----Trust Center----Trust Center Settings, click "Trusted Locations"

Table Figure-6

Select "Add New Location", click "Browse" in the pop-up dialog box, select the location of your file, and check "Also trust sub-locations in this location" Folder", OK

Excel Figure-7

Click OK again, close excel2016, and then open it File, this time open the file normally.

Excel Figure-8

The above are the tips for repairing damaged Excel files.

The above is the detailed content of How to Repair Corrupted Excel Files. For more information, please follow other related articles on the PHP Chinese website!