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

Tashreef Shareef
by Tashreef Shareef
Windows & Software Expert
Tashreef Shareef is a software developer turned tech writer. He discovered his interest in technology after reading a tech magazine accidentally. Now he writes about everything tech from Windows to iOS and streaming services... Read more
Affiliate Disclosure
  • Excel documents with read-only attributes prevent users from editing the document.
  • Here's how you can resolve the workbook was opened in read-only mode message in Office 365.
  • Want to explore some more information? Do this by finding out more on Microsft SharePoint.
  • Interested in more Microsoft Office articles? Visit our dedicated Microsoft Office hub.
Protected View office 365
To fix various PC problems, we recommend Restoro PC Repair Tool:
This software will repair common computer errors, protect you from file loss, malware, hardware failure and optimize your PC for maximum performance. Fix PC issues and remove viruses now in 3 easy steps:

  1. Download Restoro PC Repair Tool that comes with Patented Technologies (patent available here).
  2. Click Start Scan to find Windows issues that could be causing PC problems.
  3. Click Repair All to fix issues affecting your computer's security and performance
  • Restoro has been downloaded by 0 readers this month.

When you are trying to edit a workbook shared with you, you may encounter the This workbook was opened in read-only mode error. This prevents the user from editing the workbook in Excel Online and desktop app.

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

  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.

idee restoro Still having issues? Fix them with this tool:
  1. Download this PC Repair Tool rated Great on (download starts on this page).
  2. Click Start Scan to find Windows issues that could be causing PC problems.
  3. Click Repair All to fix issues with Patented Technologies (Exclusive Discount for our readers).

Restoro has been downloaded by 0 readers this month.

This article covers:Topics: