EXCEL IS CORRUPTED, CAN T BE OPENED OR REPAIRED, HOW TO FIX, OPEN.

1. Turn on the computer, then open the excel on the computer, and then click the file in the upper left corner.

2. Click to open the pop-up interface.

3. In the pop-up interface, click to select the excel document you want to repair.

4. After that, click the drop-down arrow on the side of Open, the pop-up interface, click Open and Repair to repair the document.

5. After that, restart the computer and turn it back on.

Excel is corrupted and cannot be opened or repaired, the specific steps to repair it are as follows:

The materials we need to prepare are: computer, excel**.

1. First of all, we open the required excel**, take you to click "Open" in the open file, select "Browse", and click to open the excel** you want to repair.

2. Then we click to select the file in the pop-up window, click the inverted triangle in the lower right corner to open the back and select "Open and Repair".

3. Then we click to open "Repair" in the pop-up window.

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.

Second, excel as seen in the fix.

Solve the problem that the operating system cannot open excel

The method is actually very simple, and it only takes a few steps.

1. Open Excel.

2. Click File.

3. Click Options.

4. Click Advanced.

5. Remove the checkmark in front of "Ignore other applications that use Dynamic Data Interchange (DDE)".

6. Then click OK.

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:

The Fix to [workbook name] will openxlsx 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

end 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 Click: If the data of the workbook is corrupted, a prompt message will pop up when the workbook is opened, prompting the workbook to find unreadable content, click the "Yes" button in the prompt dialog box to open the "Repair to [workbook name] xlsx" dialog box, which states 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.

Click File in the top left corner of the blank program. Click Options in the File menu. In the options, select Trust Center, Trust Center Settings.

Select the protected view in the Trust Center settings sidebar, uncheck the three checkboxes, and click the OK button to open it again. Go to Excel2016 Options, Trust Center, Trust Center Settings, and click Trusted Locations, detailed steps:

1. Excel2016 prompts that the file is corrupted and cannot be opened after opening, click OK.

2. Click File in the upper left corner of the blank program.

3. Click Options in the File menu.

4. Select Trust Center in the options, Trust Center Settings.

5. Select the protected view in the sidebar of the Trust Center, remove the three checkboxes, and click the OK button to open it again.

6. Enter Excel2016 Options, Trust Center, Trust Center Settings, and click Trusted Position.

7. Click Add New Location, click Browse in the pop-up dialog box, select the location of your file, check the subfolder that also trusts this location, and click OK.

8. Click OK to close Excel2016, open the file, and open it normally.

Excel** corruption and inability to open is usually caused by the Office Protected View, and the solution is as follows:

1. Open the data**, the prompt "The file is corrupted and cannot be opened" appears, click the OK button;

2. After entering the blank program interface, click the file option in the upper left corner of the blank program;

3. Click "Options" at the bottom of the file menu on the left side;

4. In the pop-up window, select Start, Trust Center, and Trust Center Settings at the top;

5. After selecting the protected view on the left side of the trust center, uncheck the 3 options on the right, which are to enable the protected view for files from the Internet, enable the protected view for files located in potentially unsafe locations, and enable the protected view for attachments in Outlook;

6. After clicking the OK option in the lower right corner, ** will be normal.

Although sometimes we may operate corrupted excel file. That's why when it comes to excel** corruption repair, we need to pay attention to the following important things:

Make sure your files are backed up before they get corrupted. Make sure that every file is properly backed up before it gets corrupted. This way, you won't be stuck in a passive state when you find out afterwards that the excel file contains important information. If there is no backup, the corrupted excel file must be restored first.

Changing the file extension can help us recover our files. When you change the file extension from the past to something else, you don't completely lose the information in those files. This is because if you change this extension back to the original extension, you can also retrieve the information in the original file.

If the file can't be repaired, you can try itLost document repairIt can quickly repair damaged documents, and solve file damage caused by power failure, accidental deletion, unsaved, virus, stuck, etc.

Summary. 1.Check if the file is corrupted:

Open Excel, click the "File" menu, and select the "Open" command, in the open file dialog box, see if the file type is "All Files", if so, see if the extension of the file is. xls or. xlsx, if not, then the file is corrupted.

2.Try to recover files: If the files are corrupted, you can try to use the recovery function of Excel, click the "File" menu, then select the "Open" command, in the open file dialog box, click the "Recover" button, and then select the files you want to recover, then you can try to recover the files.

3.Try to update Office: If you still can't open the excel file, you can try to check if the Office on your operating system is the latest version, if not, you can try to update Office so that you can get the latest features and improvements.

4.Try other software: If you still can't open the excel file, you can try to use other tools to try to open the file, such as LibreOffice or Apache OpenOffice, etc., which all support the opening of excel files.

Thank you for your question, I hope it helps.

1.Check whether the file is corrupted: Open Excel, click the "File" menu, then select the "Open" command, in the open file dialog box, check whether the file type is "All Files", if so, check whether the file extension is.

xls or. xlsx, if not, then the file is corrupted. 2.

Try to recover files: If the files are corrupted, you can try to use the recovery function of Excel, click the "File" menu, then select the "Open" command, in the open file dialog box, click the "Recover" button, and then select the files you want to recover, then you can try to recover the files. 3.

Try to update Office: If you still can't open the excel file, you can try to check if the Office on your operating system is the latest version, if not, you can try to update Office so that you can get the latest features and improvements. 4.

Try other software: If you still can't open the excel file, you can try to use other tools to try to open the file, such as LibreOffice or Apache OpenOffice, etc., which support Excel file playing. Thank you for your question, I hope it helps.

One. In Excel, click the menu File > Open > Select this file" button"Open"The drop-down arrow next to "Open and Fix, give it a try.

Two. See if other repair tools such as EasyRecovery or ExcelFix can do it again.

Concept Data company offers a repair that specializes in repairing Excel corrupt files.

The duplicate tool excelRecovery is able to recover Excel files.

After installation, you can automatically add the excel fix to the excel application in the ".

There is an additional "Recovery" option under the "File" menu, which can be used if there are corrupted files.

This option to fix it.

> way to use it is:

1. Open Excel.

>2. Click the "Recover" option under the "File" menu, Excel Recovery.

The dialog box will open;

3. Specify the excel file to be repaired, and then press the [recover] button;

>4. Automatic repair;

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

> note: This demo version can only repair normal files, not with Visual Basic

**, charts, and an excel file containing the password.

Three. If that still doesn't work, you can use Notepad to open it and sort out the rest of the data in it.

Pro, 1. First open a blank**, click "File" in the upper left corner. 2. Then click "Open" on the left side and find "Browse". 3. Find the location of the file you want to repair and select the file.

4. Click on the bottom left corner after "Open" and select "Open and Repair". 5. Then in the pop-up dialog box, select "Repair". 6. Wait for the file to be repaired, click Close, and the file will be repaired.

Questions. Open a blank space in **.

Dear, blank** is just to find a random one.

Dear, you can choose to create a new one on the desktop.

Questions. I don't have a desktop.

No. Pro, right mouse button, and then New.

Then select Create a new blank one.

Questions. <>

I don't say it.

Dear, when you right-click the mouse to select the desktop, do not select the folder.