How to Repair Multiple Excel Files by Using Stellar

With Stellar Repair for Excel, it is quite easy and simple to repair multiple MS Excel (XLS and XLSX) files that are damaged. This is because the software has a self-explanatory interface and hence is a Do-it-yourself software. Nonetheless, when using this software to repair multiple Excel files, you would have to add all of the files into the software by following a few pre-defined steps. Follow the steps mentioned below:

• Launch Stellar Repair for Excel software.
• Under Home menu, click Select file

• Click Browse and select corrupt Excel files. Select the checkbox to repair multiple files.

• Click Repair
• The software provides the preview facility. You can check the it on left pane.

• Save the repired filr ether Default location or Select New Folder radio button.

Stellar Repair for Excel Stellar Repair for Excel is the best choice for repairing corrupt or damaged Excel (.XLS/.XLSX) files. This Excel recovery software restores everything from corrupt file to a new blank Excel file.

Learn More

[Fixed] The Workbook Cannot Be Opened or Repaired By Microsoft Excel

An MS Excel workbook (.XLS/.XLSX) file may not open due to damage or corruption caused by various reasons, such as:

• Sudden power failure
• System crash
• Virus or malware intrusion
• Large or oversized Excel file
• Incompatible add-ins
• Drive errors
• Damaged MS Office/Excel program files

As a result, when you try to open or access a corrupt Excel document, the program displays errors, such as “The workbook cannot be opened or repaired by Microsoft Excel because it is corrupt.” This may lead to a data loss situation.

Methods to Fix ‘The Workbook Cannot Be Opened’ Error

When an Excel workbook gets corrupt, MS Excel automatically detects and starts the file recovery mode to open and repair the file. However, when it fails to repair the corruption or recover the Excel file automatically, it displays the error message, “The workbook cannot be opened or repaired by Microsoft Excel because it is corrupt.” In such a situation, you can follow these methods to repair and recover the Excel document manually.

If the manual methods fail to resolve the error, you can use an Excel repair software, such as Stellar Repair for Excel. The software repairs corrupt XLS/XLSX file, recovers all the data, and saves it in a new Excel document with 100% precision, while keeping the cell formatting and properties intact.

NOTE: Before performing the below methods to repair or recover Excel documents, create a backup copy of the original file. This will help you recover data by using an Excel repair tool and avoid permanent data loss.  

1. Repair Excel Workbook Manually

If the automatic repair fails, you may try manual repair to fix the damage or extract the data from the damaged Excel workbook. The steps are as follows:

• Navigate to File > Open and then go to the location where the spreadsheet is located.
• In the Open window, select the corrupted workbook that you want to fix and then click on the arrow next to the Open button.
• From the available options, choose Open and Repair…

• Then click ‘Repair‘ if you want to recover maximum data from the workbook or click ‘Extract data‘ if the repair option fails to fix the issue. It will extract all the values, formulas, tables, etc., from the corrupt workbook.

If both options fail to fix the issue, head to the next method.

2. Remove Faulty or Incompatible Add-ins

Faulty or incompatible add-ins may also cause this error. To find and remove such add-ins, follow these steps:

• Press **Windows key + R.
  **

• Type Excel /safe and press ‘Enter‘ or click ‘OK.’ This opens MS Excel in Safe Mode.
• Go to File > Options and then select ‘Add-ins.‘

• Choose ‘Excel Add-ins‘ from Manage: option and then click on the Go button to view all Add-ins.

• Uncheck the checkboxes of Add-ins and then click ‘OK‘ to disable them.

Now close the Excel program and run it normally. Click ‘File > Open‘ and choose the Excel file you want to access.

3. Repair MS Office Installation

Damaged Excel program files may also lead to such errors. However, you can easily repair MS Office installation to fix the problem. The steps are as follows:

• Open Control Panel and select ‘Uninstall a program.‘

• Search and choose MS Office from the programs list. Then click on the ‘Change’ button.

Click here


• Select ‘Repair’ and follow the wizard to fix the damaged program files.

If this fails to address the issue, you can uninstall and then fresh install MS Office on your system. Alternatively, try accessing the file on another PC.

4. Use Excel Repair Software

The best option is to use an Excel repair software, such as Stellar Repair for Excel , to repair the file, resolve the error, and access the Excel (XLS/XLSX) worksheet. The software can repair an Excel file without any size limitation.

After recovering the Excel file using the software, you can open it in any MS Excel program without encountering the error message.

Conclusion

A corrupt or damaged Excel workbook may lead to errors, such as “The workbook cannot be opened or repaired by Microsoft Excel because it is corrupt,” and cause a data loss situation. The most efficient way to fix such corrupt Excel files is to repair them by using an Excel repair tool, such as Stellar Repair for Excel.

Unlike manual methods that may fail to resolve the issue or lead to further damage, this software extracts the data from the damaged Excel file and saves it in a new Excel workbook. Thus, it is 100% safe to run on an original Excel file, as it does not overwrite or alter the original file.

The software is free to download. You can scan, repair, and preview a corrupt Excel file by using the demo version. Once you are satisfied with the results, activate the software to save the repaired Excel workbook data in a new sheet.

Solutions to open Excel Read Only Documents

‘Excel cannot open read-only documents’ is an error message that usually appears when you try to open an Excel (XLS or XLSX) file downloaded from the Internet, email, or the network server. It may also appear when you try to open an encrypted or password-protected Excel document. In such a case, MS Excel prevents the user from making any changes to the document.

Reasons behind the “Excel cannot access ‘xxx.xls.’ The Document may be read-only or encrypted” Error

There could be several reasons that may cause the error. Some of them are as follows:

• Corrupt or damaged Excel workbook
• Incompatible or unsupported add-in
• Antivirus or malware software conflict
• Read-Only Excel file
• The file is encrypted
• File or drive read/write permissions issues
• Protected Excel workbook
• Damaged or missing MS Office (MS Excel) program files

Solutions to Open and Edit Read-Only Excel Documents

Below are a few solutions that can help you fix the ‘Excel cannot access ‘xxx.xls.’ The Document may be read-only or encrypted’ error and allow you to open and edit Excel documents.

• Remove Read-only Attribute from Excel File Properties

The ‘Excel cannot open read-only documents’ error message may appear when the Excel file property is set to read-only. To check if this is the case, follow these steps:

• Right-click on the particular Excel (xls/xlsx) document and select ‘Properties’.
  • Uncheck the ‘Read-only’ attribute and then click the ‘OK’ button.

Now try to open the Excel document and check if the problem is fixed.

• Adjust Antivirus Settings

A few antivirus programs block Excel files and other Office documents by opening those in ‘read-only’ mode. In such cases, try adjusting the antivirus settings to open the Excel files normally. This will allow you to edit, modify, and save the Excel workbook without encountering the “Excel cannot access ‘xxx.xls.’ The Document may be a read-only or encrypted” error message.

• Disable Protected-View

The error may appear when you try to open an Excel file received as email attachments or downloaded from unsafe source. The file may potentially contain viruses, worms, or other types of malware that could damage the system or the server.

To safeguard the system, MS Excel opens such files in Protected View. It may also open an Excel workbook in Protected Mode when it detects a problem with the file. This security feature allows you to read or view Excel files and reduces the risks to the computer system or PC.

However, you can click File > Info and then click ‘Edit Anyway‘ to access and edit file content. You may also disable the Protected View setting via File > Options > Trust Center > Trust Center Settings…> Protected View. However, we do not recommend this.

• Renew/Activate Microsoft Office

If MS Office is in a deactivated state or its subscription has expired, the Office documents, including the Excel, could be in ‘read-only reduced functionality mode.’

In such a scenario, activate Microsoft Office or renew the Office subscription. Then open the Excel workbook and check if the problem of ‘Excel cannot open read-only documents’ is resolved.

• Check if OneDrive Storage is Full

If Excel files are saved on OneDrive with low or no storage space, you may encounter such issues with your files.

To know the amount of free space on OneDrive, follow these steps:

• On your PC, open Settings and navigate to OneDrive.
  • Click ‘Sync Settings > File Storage‘ to see available space.

You may also visit onedrive.live.com, sign in to the account, and then check the available space. If there’s no space available or the drive is full, empty the storage space and see if the problem is resolved.

• Check and Update MS Office and Windows

Microsoft releases updates to fix known errors. Thus, it is critical to update both Windows and MS Office to the latest release and avoid issues, such as ‘Excel cannot access ‘xxx.xls.’ The Document may be read-only or encrypted.’

• Repair MS Office (MS Excel)

The error ‘Excel cannot open read-only documents’ may appear due to a problem with your MS Office (MS Excel) program. You can repair the MS Office program to resolve such errors. The steps are as follows:

• Open Control Panel and click Uninstall a Program link under Programs.
• Choose Microsoft Office from the list and click the Change button.

Click here


• Select Quick Repair and then click Repair to fix problems with MS Office and MS Excel. It will also restore any missing or damaged program files.

After the Repair, open the Excel workbook and check if the error is resolved.

• Check Permissions

The error message may also appear if you access an Excel workbook from a network or shared drive due to lack of write permission. Make sure you have read and write permissions assigned for the particular network drive. Alternatively, you can copy the file from the network drive and save it in your local folder to access and edit it without encountering this error message.

• Repair MS Excel File

If none of the solutions worked, the Excel workbook could be damaged or corrupt. To repair such damaged Excel workbook or spreadsheet, you can use the inbuilt ‘Open and Repair…’ option in MS Excel or install an Excel repair software , such as Stellar Repair for Excel. The software comes in handy when the Open and Repair option fails to fix the Excel workbook problems. It repairs the corrupt or damaged Excel workbook, extracts all components and content from the file with 100% integrity, and saves them in a new Excel workbook.

Conclusion

Sometimes, the ‘Excel cannot open read-only documents’ error can be resolved by a simple restart. But if it doesn’t work, you can follow the solutions discussed in this article to resolve the ‘Excel cannot open read-only documents’ issue.  However, if the issue is caused due to a damaged or corrupt Excel workbook, these methods may not work. In such a case, you can use Excel’s inbuilt repair utility, i.e., Open and Repair, or install Stellar Repair for Excel software recommended by MVPs and industry experts to fix all kinds of problems with MS Excel workbooks.