Lagos, Nigeria

FIX: This workbook was opened in read-only mode [Office 365]

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

  1. If you can download these workbooks to your local computer, download a copy.
  2. Right-click on the downloaded copy and select Properties.
  3. Check if the Read-Only attribute is checked. Uncheck the Read-Only attribute and click OK to save the changes.
  4. Next, open the Security tab. Make sure you have full control of this file.
  5. Close the properties window, and open the workbook with your Excel app to see if the error is resolved.

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

workbook was opened in read-only mode

  1. Launch the Excel app.
  2. Click on File and then select Options.
  3. Click on Trust Center and select Trust Center Settings.
  4. Go to Protected View.
  5. Next, clear all the three boxes of Protect View on the right panel.
  6. Close the Settings window and relaunch the Excel app.
  7. Open the workbook and check if the error is resolved.

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

workbook was opened in read-only mode

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?

Protected View office 365
  1. Right-click on the SharePoint document and select Properties.
  2. Open the General tab.
  3. Uncheck the “Read-only” box.
  4. Click Apply and then on OK to save the changes.

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?

Protected View office 365
  1. Open File Explorer.
  2. Right-click on OneDrive and select Properties.
  3. Open the General tab.
  4. Under Attributes, uncheck the “Read-only” box.
  5. Click OK to save the changes. If you see a prompt asking if you want to apply the changes to all folders, subfolders, and files, click OK.

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.

This post was written by Tashreef Shareef and was first posted to WindowsReport

Do you find this article helpful? Your Friend might too. So, please Share it with them using the Share button above.
Will you like to get notified when I post new updates? Then Follow me on any of my social media handles: Google News, Telegram, WhatsApp, Twitter, Facebook, Pinterest.
You can also drop your email address below if you wish to be notified by mail.

[newsletter_form type="minimal" lists="undefined" button_color="undefined"]

Tags: , , ,