Resolve shared Excel opening as a read only file

Home > Search
  by

In this example, an Excel file is opening as Read Only.

 


Ensure the Read-only attribute is not enabled.

  1. Right-click on the file, select Properties
  2. Ensure Read-only is not ticked.

 


Disable Protected View

  1. In Excel, select File > Options.
  2. In the left panel, select Trust Center.
  3. Select Trust Center Settings.
  4. In the left panel, select Protected View.
  5. Remove the tick for every option.

 


Unprotect the sheet

  1. At the top of the read only Excel file, select the Review tab.
  2. If Unprotect Sheet is an option, select Unprotect Sheet. There will likely be a prompt to enter a password. You will need to know the password to unprotect the sheet.

 



Add a Comment




We will never share your name or email with anyone. Enter your email if you would like to be notified when we respond to your comment.




Please enter in the box below so that we can be sure you are a human.




Comments