The Excel document which I am trying to open shows me an error message: Cannot access read-only document. I could open this document a month ago. Please advise the solution. How to stop the error?
3. Third, there are also free tools from third-parties that can open and read Microsoft Excel files, for example,
3.1 OpenOffice . This is a very famous open source project that is designed to support Office file formats, including Excel files. The software can run under Windows.
3.2 KingSoft Spreadsheets . This is a free Windows tool that can open Excel files.
Sometimes when Excel fails to open your file, these tools may be able to open it successfully. If that is the case, then after the Excel file is opened, you can just save it as a new file which will be error-free.
4. For xlsx files, they are actually a group of files compressed in Zip file format. Therefore, sometimes, if the corruption is only caused by the Zip file, then you can use Zip repair tools such as WinRAR to repair the file, as follows:
4.1 Assuming the corrupt Excel file is a.xlsx, then you need to rename it to a.zip
4.2 Start WinRAR, go to "Tools > Repair Archive" to repair a.zip and generated a fixed file a_fixed.zip.
4.3 Rename a_fixed.zip back to a_fixed.xlsx
4.4 Using Excel to open a_fixed.xlsx.
There may still be some warnings when opening the fixed file in Excel, just let ignore it and Excel will try to open and repair the fixed file. If the file can be opened successfully, then you can just save the contents into another error-free file.
5. If all above methods do not work, then you may try third-party tools. Nearly all these tools provide a free demo version so that you can try to see if the data you want can be recovered or not.
balles0987
3 Posts
6853
0
Posted March 22nd, 2017 06:00
Can someone help me with this issue?