If you are trying to edit an Excel 2013 document but you keep seeing an error message saying the document is marked as read-only, there are several ways to go around this restriction. Read-Only can be a great way to prevent others from editing the text on the document, but in some cases it can be a problem when you lost the read only password. The how to disable read only in excel 2013? The method you use to disable read only in Excel 2013 will depend on how the document was made read only. All the cases and its most effective solution include the following:
1. If Excel 2013 is Read-Only Recommended
When you open an Excel 2013 document that is read-only recommended, you will see a prompt that says, “the author would like you to open '***.xlsx' file as read-only unless you need to make changes…" If you choose “Yes” you may be able to make changes on the document, but you will not be able to save it in the same location. If you choose “No” you will essentially disable the read-only restriction and then be able to edit and save the document. You can also choose to “Cancel” if you don’t want to open the document.
If you want to remove this read-only recommendation, you can do that in the following simple steps:
Step 1: Open the Excel file and then click on File > Save As.
Step 2: In the “Save As” dialogue box, click on “Tools” and then select “General Options”.
Step 3: Uncheck “Read-only recommended” and then click “OK” and save the document.
2. If the Excel 2013 is Set to Read Only with Restrict Editing Password
If on the other hand the Excel 2013 document is read-only with a restrict password, you will be required to enter a password every time you want to edit the document or choose “Read-Only” to open the restricted file. If you open the file in read only mode, you may be able to make change, but you won’t be able to save the document in the same location. The only way to disable read only in excel 2013 with this restriction therefore is to save the document in a different location or as a new file.
Step 1: Open the protected document and when prompted for the password, click on “Read only” instead to open a read-only version of the document.
Step 2: Now click on “File > Save As” and enter a new name for the file or change the location. The new file will be editable.
3. If Excel 2013 is Marked as Final
Another way users can restrict editing on an Excel 2013 document is to Mark it as Final. In this case, you should see a big yellow bar at the top of the document with “Marked as Final” on it. When a document has been marked as final, its data on it will not be edited.
To remove read only in the Excel 2013 document, click on “Edit Anyway” and the restriction will be lifted allowing you to edit the document.
4. Disable Read Only in Excel 2013 Using Windows Explorer
You may also be able to remove read-only in Excel 2013 documents in Windows Explorer. Follow these simple steps to do it:
Step 1: Find the restricted Excel 2013 document and right click on it. Select “Properties” from the options presented.
Step 2: In the “Generals” tab, look for “Read-only”. Uncheck the box if it is checked to disable the read-only restriction.
5. Disable Read Only in Excel 2013 without Password (Supports All Cases Above)
While the methods above may be effective in lifting restrictions from an Excel 2013 document, there is a more simple and straightforward solution that will work regardless of how the read-only restriction was placed on the 2013 document. This is Passper for Excel, a document password recovery tool that is also highly effective in removing any and all restrictions from an Excel document. It is even workable to recover the password to open your locked Excel document. And we guarantee the 100% success rate to disable read only in 2013 and other versions of Excel. It will even work if a password has been used to restrict editing.
The following is a simple guide to help you disable read-only in Excel 2013 using Passper for Excel:
Step 1: Install the program on your computer and then launch it. Click on “Remove Restrictions” to begin the process.
Step 2: Click on “Add” to import the read-only 2013 document into the program.
Step 3: Once the document is on the program, click “Remove” and Passper will begin removing the read-only restriction from the document.
In a few minutes all read only restrictions on the document will be removed and you can now make changes to the document.
The above solutions can all help to remove read only in Excel 2013. Select the most appropriate method based on the nature of the read-only restriction.