Disabling protected view to edit excel files
Bạn đang xem: Disabling protected view to edit excel files
Tip: Though this post is based on Excel Protected View, it is also applied for Word Protected View và PowerPoint Protected View.
What Is Protected View?
Protected View is an isolated sandbox environment for Excel, Word, và PowerPoint. It is offered by Microsoft Office to replace the former Isolated Conversion Environment. Protected View is a read-only mode where most editing functions are disabled.
Protected View is available for Office 365, Office 2019, Office 2016, Office 2013, và Office 2010. Yet, if you are using Office versions older than 2010, you are able lớn upgrade from the Isolated Conversion Environment to lớn the Protected View.
Why Use Protected View?
Files coming from the internet or other potentially unsafe locations may contain malware, spyware, adware, ransomware, viruses, worms, trojan, etc. That will attack your computer. Therefore, to prevent PC from those attacks, those files are opened in the read-only mode or in Protected View.
In Protected View, you are able to lớn read a file and enable editing while reducing the chance lớn be infected, hacked, or hijacked.

Why won’t Excel open? How to khuyến mãi with Microsoft Office Excel won’t open problem in Windows 10/11 operating systems? Here are 11 methods for you to lớn choose.
Read More
Protected View Cases
When will you encounter Protected View errors? Which kind of file will be opened in Protected View? Just as mentioned above, in these situations, you may receive a message of Protected View.
Case 1. A tệp tin is opened online
“PROTECTED VIEW Be careful – files from the internet can contain viruses. Unless you need to lớn edit, it’s safer to stay in Protected View.” (yellow warning)
Case 2. A tệp tin is opened from an unsafe location
“Protected View This tệp tin was opened from a potentially unsafe location. Click for more details.” (yellow warning) The unsafe location can be your Temporary internet Files folder.
Case 3. A tệp tin is an Outlook attachment và your computer policy defines the sender as unsafe
“PROTECTED VIEW Be careful – thư điện tử attachments can contain viruses. Unless you need to lớn edit, it’s safer to lớn stay in Protected View.” (yellow warning)
Case 4. A file is blocked by file Block
“PROTECTED VIEW Editing this tệp tin type is not allowed due to your policy settings. Click for more details.” (yellow error)
OR
“PROTECTED VIEW Editing this file type is not recommended due khổng lồ your tệp tin Block settings in the Trust Center. Click for more details.” (yellow warning)

Case 5. Tệp tin validation failure
“PROTECTED VIEW Office has detected a problem with this file. Editing it may harm your computer. Click for more details.” (red error)
Case 6. A file is opened from others’ OneDrive storage
“PROTECTED VIEW This file is from someone else’s OneDrive. Unless you trust this person and want lớn continue collaborating with them, it is safer to stay in Protected View.” (yellow warning) You may encounter such A warning message when someone shares an OneDrive tệp tin with you.
Xem thêm: Hướng Dẫn Cách Tạo Cuộc Trò Chuyện Bí Mật Trên Facebook Messenger
Case 7. A file is opened using the “Open in Protected View” option
“PROTECTED VIEW This file was opened in Protected View. Click for more details.” (yellow warning)
Tip: Administrators have access to lớn specify the các mục of potentially unsafe locations lớn include additional folders they think unsafe.
Besides, sometimes the Protected View message appears for files that are damaged in the following situations:
An unexpected error occurred while copying the file to your PC. This error can be caused by a problem with your mạng internet connection.The file is created or edited with a problematic program.The file-located disk is damaged.The way Office looks for dangers in a tệp tin is wrong.What Office tệp tin types can cause file-validation errors?
Word 97-2003 (.doc, .dot)PowerPoint 97-2003 (.ppt, .pot, .pps, .ppa)
Excel Turn off Protected View
If you trust the files and want to edit, save, or print them, you can vị Excel disable Protected View. Then how to lớn get out of Protected View in Excel?
Way 1. Remove Protected View Excel from Yellow Message Bar
On the yellow warning message banner, exit Protected View by clicking Enable Editing.
Way 2. Excel Disable Protected View for Red Message Bar
Remove Protected View from Excel by clicking File on the upper left & select Edit Anyway.
How khổng lồ Change Excel Protected View Settings?
How khổng lồ alter the Protected View Settings to stop Excel from opening in Protected View once and for all? Just do lượt thích this.
Step 1. Mở cửa an Excel file & click File > Options.
Step 2. In the new Excel Options window, click Trust Center > Trust Center Settings.
Step 3. In the next Trust Center window, choose Protected View in the left menu.
Step 4. Now, specify your settings.
Related article: Fix Excel Not Responding và Rescue Your Data (Multiple Ways)
Anyhow, you are recommended to lớn edit the document only if you trust its contents. Otherwise, it’s safe to lớn stay in Protected View!
Chuyên mục: Tin Tức