Bootstrap FreeKB - Windows - Resolve shared Excel opening as a read only file
Windows - Resolve shared Excel opening as a read only file

Updated:   |  Windows articles

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.

 




Did you find this article helpful?

If so, consider buying me a coffee over at Buy Me A Coffee



Comments


Add a Comment


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