How to Remove Protected View in Excel (3 Quick Methods)

To explore the methods, we’ll use the following dataset representing the hourly rate of some ExcelDemy content writers.


Method 1 – Remove Protected View by Clicking Enable Editing Button in Excel

Note – this is not a permanent solution, ie the method will need to be applied individually to each Excel file where removal of Protected View is required.

STEPS

  • Click the Enable Editing Button under the ribbon.

Remove Protected View by Clicking Enable Editing Button in Excel

Protected View mode is removed.

Read More: Cannot Edit Excel File in Protected View


Method 2 – Clear Protected View Using the Info Option

This is the same impermanent command used in Method 1, just accessed from a different location.

STEPS

  • Click the File tab.

Clear Protected View Using Info Option

  • Select Info ➤ Enable Editing.

Clear Protected View Using Info Option

Protected View mode is removed.

Read More: [Fixed] Excel Protected View Editing This File Type Is Not Allowed


Method 3 – Permanently Remove Protected View via Trust Center Settings in Excel

This method is particularly useful when opening files downloaded from a trusted source using an AntiVirus.

STEPS

  • Click on the File tab.

Permanently Remove Protected View from Trust Center Settings in Excel

  • Select Options from the menu.

Permanently Remove Protected View from Trust Center Settings in Excel

  • The Excel Options dialog box will open.
  • Select Trust Center > Trust Center Settings.

Permanently Remove Protected View from Trust Center Settings in Excel

  • Another dialog box opens.
  • Click Protected View on the left menu.
  • Unmark all options in the Protected View section.
  • Click OK to return to the previous dialog box.

Permanently Remove Protected View from Trust Center Settings in Excel

  • Click OK.

Protected View will be permanently disabled, and all Excel files will now open in Edit Mode by default.

Read More: [Solved]: Excel Protected View Office Has Detected a Problem with This File


Download Practice Workbook


Related Articles


<< Go Back to Excel Files | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Sourov Hossain Mithun
Md. Sourov Hossain Mithun

Md. Sourov Hossain Mithun, an Excel and VBA Content Developer at Softeko's ExcelDemy project, joined in October 2021. Holding a Naval Architecture & Marine Engineering degree from BUET, Mithun showcases expertise during his two-year tenure. With over 200 published articles on Excel topics, he earned a promotion to Team Leader, excelling in leading diverse teams. Mithun's passion extends to Advanced Excel, Excel VBA, Data Analysis, and Python programming, contributing significantly to the innovative and dynamic environment of ExcelDemy... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo