What is Protected View in MS Excel 2010 and how to disable it?

-
Protected View is a new security feature in MS Excel 2010. Whenever you open a file downloaded from Internet in Excel 2010, it will open in Protected View. Since files downloaded from Internet, received as an email attachment and from other unsafe location may contains viruses and can harm your computer so to minimize the risk of these security threats, files are opened in Protected View. In Protected View, you cannot edit your file until you click the Enable Edition option. If you want to edit file, click the Enable Editing button as shown in the below image:


What does Protected View message indicates?

You will receive different warning message depending upon your file location. If you have downloaded your file from Internet then you will receive below message:
 Files that you download from Internet can have viruses and other harmful contents so it is recommended to edit the file only if you trust the file location.

If you have received your file as an email attachment then you will receive below warning message:
This message occurs because the file that you have received might be send by a unsafe sender.

If you have opened your file from an unsafe location then you will receive below error message:
This message occurs because you have opened your file from untrusted or unsafe folder for ex Temp folder.

How to disable Protected View?
If you know that file is from a trusted source and you want to make changes in the file then you can always disable Protected View mode. You can permanently disable Protected View by following below steps:
  1. Open your Excel file.
  2. Go to File-> Options.
  3. On the left side, click Trust Center-> Trust Settings.
   4. Now click Protected View and uncheck the options that you don't want.


Next time when you open your document, it will not open in Protected View. 

Sometime you cannot exit Protected View even after clicking the Enable Editing button or by disabling Protected View. In this case consult with your system administrator to solve this problem.

Comments

  1. nima25 April 2017 at 11:43

    Kind of bizarre because this article doesn't tell you how to actually repair the file as the title claims. It only shows you how to disable protected view.

    ReplyDelete

Post a Comment

Popular posts from this blog

How to Fix Issues with Excel File Save

-
Sometimes users face problem in saving Microsoft Excel files. Excel shows different type of error messages while saving the file such as “Errors were detected while saving C:/Users/Filename.xlsx”, “an error message indicating the document was not saved or that someone else is using the file and can’t be saved”. You may face these types of issue while saving Microsoft Excel files if one or more of the following conditions are true. You have limited permissions to a network drive and you are trying to save an Excel file there. You do not have sufficient drive space and trying to save an Excel file to that location. While saving the Excel file, you have lost the connection to the file. Antivirus software program arise conflicts with the Excel file save. You are trying to save a shared Excel file. The path length for the Excel file exceeded than 218-characters. Excel file is damaged or some data in the file is corrupt. Here are some methods to troubleshoot Excel saving prob
Read more

How to resolve MS Access error “Cannot find the database you specified”?

-
Yesterday I had received an email from my friend regarding an error in MS Access. My friend was getting an error message due to which she was unable to open her Access file. Whenever she clicked on MS Access database shortcut to open her file, an error message pop ups on her screen. Initially I didn't understand the reason behind the error but after searching for hours on internet, I got the solution. The error was: “Cannot find the database you specified, or you didn't specify a database at all”.
Read more

How to resolve Excel error “MS Office Excel is waiting for another application to complete an OLE action"

-
Image
It is not uncommon to receive error messages in Excel. Sometime these error messages are so strange and weird that it becomes very difficult to understand them. Today I will talk about one such error in Excel. “MS Office Excel is waiting for another application to complete an OLE action.” The above error may occur when you try to open your Excel sheet. There are three main reasons for the occurrence of this error: This error may occur when you use 'Send as Attachment' option of Excel to send the Excel sheet as an email attachment. If Excel is trying to access data from an active application. You have added too many add-ins in your application.
Read more