If you are storing the file in OneDrive and it is full, you may not be able to edit the file. Solution 4: Free Up Space in OneDrive Storage Read More: This Excel Workbook Was Opened in Read-Only Mode This will solve the problem if the Excel file was opening as read only because of the Protected View feature. Finally, click on OK in both the boxes and open the Excel file.Then select the Protected View tab from it and under the Protected View section, uncheck all of the protection options. As a result, the Trust Center box will open up.Then under Microsoft Excel Trust Center select Trust Center Settings.Now select the Trust Center tab in the Excel Options box.Then select Options from the left side of the preview panel.First of all, open Excel and navigate to the File tab on your ribbon.Then again, if you still want to exit Protected View, follow these steps. So this feature helps you reduce the risk for your computer. In some cases, the files do contain some potential viruses or malware. This can happen when you download the file from a potentially unsafe location, or you have downloaded it from email attachments. To protect your computer, Windows sometimes open your Excel file in Protected View. Solution 3: Turn Off Protected View Feature If the anti-virus is what is blocking you the file should be writable after that. If this is the case for you, you should look up to your anti-virus provider to unblock the file. Similarly, your Excel files may be opening as read only because the anti-virus you are using is marking it as potentially unsafe one and blocking some features. Solution 2: Remove Protection from Antivirus Read More: How to Remove Read Only from Excel (7 Easiest Ways) This will remove the read only attribute from the property of the file. After that, in the Properties box go to the General tab and uncheck the Read-only option beside Attribute.Then right-click on your file and select Properties.First, go to the location of your file.It is the most common cause of this error. If the File is already set as read only in its property it should be a read only file. If it is not corrupted, you can try out these different solutions and find out which works for you. Of course, there is a chance that the file is corrupted and is in a read only state. Also, the writer may have changed the settings to remove the viewer’s editability. It can happen because of some added security like when you are opening a file from an unknown source on the internet. Related Articles 13 Possible Solutions for Excel Files Opening as Read OnlyĮxcel files opening as read only can happen for many different reasons.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |