We work in our Excel workbook all the time. And very frequently, we need to update the worksheet or edit it. But, the Read-Only Mode prevents us from making any changes to the file. There can be some reasons for a file to be in non-editing mode. In this article, we’ll show you the possible reasons and the effective solutions for the ‘This Excel Workbook Was Opened in Read-Only Mode’ issue.
Download Practice Workbook
Download the following workbook to practice by yourself.
10 Possible Solutions: This Excel Workbook Was Opened in Read-Only Mode
1. Disable Read-Only Attribute in Excel
The Read-only attribute in the File Properties prohibits us from making any changes to the Excel file. Therefore, follow the steps below to solve this problem.
STEPS:
- First, select the Excel file and right-click on the mouse.
- Then, select Properties.
- As a result, a dialog box will pop out. There, in the General tab, uncheck the box for Read-only.
- Lastly, press OK.
- Thus, you can edit the file after opening it.
Read More: How to Remove Read Only from Excel (7 Easiest Ways)
2. Resave Excel Workbook to Deactivate Read-Only Mode
If you happen to save the file in the ‘Read-only recommended’ setting, you can’t edit it anymore. So, learn the steps below to resave the Excel Workbook to Deactivate Read-Only Mode.
STEPS:
- Firstly, open the Excel workbook.
- In the pop-out warning box, press No.
- Now, go to the File window.
- Next, click Save As ➤ Browse.
- Consequently, the Save As dialog box will emerge.
- After that, choose General Options from the Tools drop-down.
- As a result, the General Options dialog box will appear.
- There, uncheck the box for Read-only recommended.
- Finally, press OK and save the file.
- Therefore, you can make changes.
3. Fix Read-Only Mode Issue Through New Copy of Workbook
However, there is another way to solve the read-only mode problem. Hence, follow the process.
STEPS:
- First of all, edit the file as much as necessary.
- Subsequently, choose Save As in the File window, instead of Save.
- Now you can modify the Excel workbook without any difficulties.
4. Uncheck Protected View for Solving Read-Only Mode Problem
Additionally, certain settings in the Excel File Options block us from revising the workbook. Therefore, learn the following process to alter the settings.
STEPS:
- Go to File ➤ Options at first.
- As a result, the Excel Options dialog box will pop out.
- Then, in the Trust Center, click Trust Center Settings.
- Consequently, in the Trust Center dialog box, select the Protected View tab.
- Afterward, under the Protected View section, uncheck all the boxes there.
- Press OK and go back to the workbook window.
- At last, you can make changes to the file.
5. Avoid Opening in Read-Only by Removing ‘Mark as Final’ Setting
If someone sets an Excel file as the final version, you can’t edit it anymore. Hence, watch the following steps to remove the setting.
STEPS:
- In the beginning, go to the File window.
- Then, select Info.
- After that, remove the selection for ‘Mark as Final’ in the Protect Workbook.
- Also, when you open a final version of an Excel file, you’ll see a warning message like it’s shown below. There, you can choose ‘Edit Anyway’ to edit the workbook.
6. Unprotect Excel Workbook to Disable Read-Only Attribute
Moreover, if a sheet or a workbook is protected, we can’t make changes. So, learn how to unprotect it.
STEPS:
- First, go to the Review tab.
- Press Unprotect Sheet and Protect Workbook to remove the selection on them.
- Lastly, you will see the Review tab as shown in the below image.
7. Edit with Office Online
Sometimes, you can’t edit the file with the desktop MS Excel app due to the co-authoring feature. Try to edit it in Office Online. It can solve the problem.
Read More: [Fixed!] Excel Files Open as Read Only from Network (8 Quick Solutions)
8. Fix Antivirus Settings on PC
Some Antivirus apps may take the Excel files as a threat. So. they will open the files in read-only mode. Therefore, look for the Antivirus Settings where you can allow the Excel files to open normally.
Read More: [Solved]: All Excel Files Opening as Read Only (6 Ways)
9. Renew Office App to Avoid Read-Only Mode
Again, if the subscription to Office apps gets canceled or expired, you can’t edit the Excel workbook. Hence, renew the subscription to avoid the issue.
10. Update Office App When Excel Workbook Starts to Open in Read-Only Mode
If the latest version of Office apps is not installed on the PC, the Excel files from other sources may open in the read-only mode. Thus, updating the Office apps can easily remove the problem.
Read More: [Fixed!] Excel Files Opening as Read Only (13 Possible Solutions)
Things to Remember
It’s better If we can prevent the ‘This Excel Workbook Was Opened in Read-Only Mode’ problem from occurring in the first place. For that purpose, follow the below notes carefully.
- Save the files carefully. An accidental close of the file can result in a read-only mode issue.
- Track the latest updates of the MS Excel app.
- Check the subscription period of MS Office.
- Use a trusted antivirus app and check for malware regularly.
- Keep a backup copy of your Excel workbook.
- Select the option for the final version of the workbook only when you’re sure of it.
Conclusion
Henceforth, you will be able to solve This Excel Workbook Was Opened in Read-Only Mode issue by following the above-described solutions. Keep using them and let us know if you have more ways to do the task. Follow the ExcelDemy website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.