This error can occur due to several reasons, including the original document being maintained in the desktop app on the creator’s computer. It can also be triggered if your company is transitioning to SharePoint. If you are also troubled by this error, here are a few troubleshooting steps to help you resolve the This workbook was opened in read-only mode error when editing Excel files.

How do I stop Excel from opening in read only mode?

1. Disable Read-only mode

If the original document has the read-only attribute enabled, it will prevent the user from editing the file and display the error message. Make sure to uncheck the option to see if that resolves the error.

2. Disable Protected View

Protected View is the read-only mode where most editing functions are disabled to protect the users from harmful files. However, this can cause an issue with other documents as well. Make sure to enable Protected View once you have edited the workbook.

3. Close the workbook on local computer

The latest Excel app comes with the co-authoring feature. However, if you are not running the latest version of Office 365, and if the file owner keeps the file open on their Excel desktop app, you may not be able to edit that file. Make sure the file is not opened in Excel desktop, and then try to edit the file in Excel Online. Try editing other Office 365 files and see if you can edit with Office Online.

How do I change a SharePoint document from read only?

Once you have made the changes, open the SharePoint document, and check if the read-only message is resolved.

How do I turn off read only on OneDrive?

That’s it. This should resolve the OneDrive desktop app changing your documents attribute to the Read-only issue. This workbook was opened in read-only mode message usually occurs if the file owner has set the document attribute to read-only. You can resolve the problem by disabling the read-only attribute. If not, try disabling Protected View temporarily to fix the error.

Name * Email * Commenting as . Not you? Save information for future comments
Comment

Δ