Excel 2013 - Understanding the Protected View

You may have already encountered an Excel feature known as Protected View.

So what is Protected View. Weill its all about protecting you from malware.

Now you are saying to yourself... Hold on, I don't own any mid evil armor. What is all the fuss about malware and why should I care?

In a simplified definition, Malware refers to something that can harm your computer. There are many ways that hackers can manipulate Excel files so that harmful code can execute. The Protected View essentially prevents these types of attacks by opening a file in a protected environment. This is often called a sandbox by developers.

When you open an Excel workbook that you downloaded from the web, you’ll see a warning message above the Formula bar.  In addition, Excel’s title bar displays the message.






If you’re certain that the file is safe you can click Enable Editing.

If you don’t enable editing, you’ll be able to view the contents of the workbook, but you won’t be able to make any changes to it.

What causes Protected View?

Protected View kicks in for the following:

  1. Files downloaded from the Internet
  2. File attachments opened from Outlook
  3. Files opened from potentially unsafe locations, such as your Temporary Internet Files Folder
  4. Files that are blocked by File Block Policy 
  5. Files that have expired digital signatures
So be sure to know where that file comes from and when in doubt, don't enable editing.




BEGINNER, PROTECTED VIEW

1 comment:

  1. Can you help me how to protect my formula cell in Excel.

    ReplyDelete