![]() ![]() In order to unprotect the sheet, you have to open the Excel file and click on Review. To do this follow the steps below Step 1: Unprotect sheet In such a case, you have to unprotect it first before working on it. Think of a situation where you are dealing with a sheet that has been protected by a password. Take for example, in our figure 1 above, all we need to do in order to be able to edit the sheet is click on the edit Anyway button. ![]() When you open an Excel sheet and you see marked as Read Only then you will have to remove the “Read Only” for you to be able to edit it. ![]() ” The message is as shown in figure 2 below įigure 2: Protected sheet warning Enabling editing of a final sheet in Excel If we try double-clicking on the file, then we shall be prompted to unprotect it by a message “ The cell or chart you’re trying to change is on a protected sheet. Note that editing a protected sheet is not possible, unless we unprotect the Excel sheet first. Also, the file can be in an Excel protected view when its password has been modified. When the file has been sent to us, then we need to know how to disable protected view in Excel in order to work with the Excel file. First is when we have the sheet downloaded from an online source such as email. There are many instances when we have an Excel sheet in the restricted view. When this happens, you will be able to see a yellow message on top of the Excel sheet MARKED AS FINAL as shown in figure 1 below This is usually the case when the file is in a protected view Excel, where we can only read the contents but cannot edit any apart of it. There are times when we want to edit an Excel spreadsheet but then we are not able to. The three values you would want to set are:īy setting each value to 1 you will disable Protected View for that file location.How to enable editing in Excel – Excelchat HKCU\Software\Microsoft\Office\14.0\PowerPoint\Security\ProtectedView HKCU\Software\Microsoft\Office\14.0\Excel\Security\ProtectedView HKCU\Software\Microsoft\Office\14.0\Word\Security\ProtectedView If for some reason the options in Office do not work or you want to be able to automate this setting for multiple computers you can try setting one or more of these registry values below. Like most options in Windows there is a way to disable these settings via the registry too. To add more locations that are marked as safe for Protected View go back to the Trust Center Settings and click Trusted locations on the left.Ĭlick add new locations at the bottom and browse to the location you would like to add to the trusted locations list.Īny documents in the new location will now be marked as safe. Repeat these steps for Microsoft Excel and Powerpoint if you want to disable Protected View there too. Once you check or un-check the settings you want you can close the windows. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |