To close the protected view of Excel, you can do it by modifying the Trust Center settings, adding a trusted location, or temporarily closing it. 1. Modify the Trust Center settings: Go to "File > Options > Trust Center > Trust Center Settings" and uncheck the enabled conditions of the protected view; 2. Add a trusted location: Select "Trusted Location" in "Trust Center Settings", add common folders and trust its subfolders; 3. Temporary Close: Click "Enable Editing" or "Enable Content" in the prompt bar of the protected view to temporarily uncheck the restrictions. Choose the appropriate method according to the usage scenario, taking into account both convenience and safety.

If you find that the content is restricted when opening an Excel file, it appears in Protected View, which may be because the file source is considered potentially unsafe. Turning off this feature allows you to view and edit files more smoothly, but you need to be careful that this may pose certain security risks.

Here are several common ways to disable Excel's protected views.

Modify the Trust Center settings

This is the most direct way. By adjusting Excel's Trust Center options, you can selectively or completely turn off guarded views:

• Open Excel and click the "File" menu in the upper left corner.
• Select Options and click Trust Center.
• Click the "Trust Center Settings" button in the lower right corner.
• Find "Protected View" on the left, and several situations where protected views are enabled are listed on the right.
• Uncheck the options you want to disable, such as "Files from the Internet", "Files in Possible Unsafe Locations", etc.
• Confirm the save settings.

This method is suitable for you to understand the source of the file you have opened and hope to reduce the interference caused by frequent prompts.

Add a trusted location

If you often open Excel files from specific folders, such as local working directories or company shared directories, you can add these locations as "trusted locations." This way Excel will consider the files in these places to be safe and will not enter the protected view:

• Also enter the "Trust Center Settings".
• Select Trusted Location.
• Click "Add New Location" to browse and select your common folders.
• If necessary, you can also check "Trust subfolders in this location at the same time".
• Save after confirmation.

After doing this, files opened from these locations will not automatically enter the protected view, making it more convenient to operate.

Quickly temporary close protected view

If you only occasionally encounter a file that is restricted and do not want to change the settings permanently, you can also temporarily uninstall it:

• Once the file is opened, you will see a yellow warning board at the top that says "Protected View".
• Click the warning bar and select "Enable Editing" or "Enable Content" (if there is a macro).
• This way the current file exits the protected view until you close it.

This method is suitable for you to just want to process a file quickly without changing the overall settings.

Basically that's it. You can choose the right method according to your usage habits. If it is a daily office environment, it is recommended to combine "Trusted Locations" and partially disable protected views; if security requirements are not high, you can turn off all protected views options directly.

The above is the detailed content of How to disable protected view in Excel. For more information, please follow other related articles on the PHP Chinese website!