Microsoft Excel — HOW TO Disable “Protected View” in MS Excel

Microsoft Excel — HOW TO Disable “Protected View” in MS Excel

Image for postHow to Disable ?Protected View? default alert in Excel

Overview

By default, Excel activates certain ?protected view? settings. This is meant to prevent you from opening an potentially infected file downloaded from the Internet, sent to you in an Email, etc.

The reality, however, is that it typically ADDS an additional step to opening many Excel files that you receive. For instance, I regularly download Excel files from Box or Dropbox and others that I receive through email.

WARNING ? only disable this setting if you are certain that any file you open is a trusted file. This applies to computing in general ? only open those files that you expect to receive and you know are from a trusted source (friend, co-worker, etc.)

Steps to Disable Protected View

  • Open Excel, select the ?File? menu option
  • Select ?Options?

Image for post

  • Select ?Trust Center? and click on ?Trust Center Settings?

Image for post

  • Next, select ?Protected View? and un-check the desired items (all three if you use Outlook for email)

Image for post

Finally, enjoy opening all of your Excel files without the ?Protected View? nuisance banner! 🙂

About Don

Image for post

Don Tomoff is a ?recovering CPA?, who is passionate about helping professionals and organizations keep up and adapt to the changing business world that we operate in.

One lesson learned over the years is that all of us, regardless of organization type or size, struggle with similar issues ? primarily information management and presentation, and effective use of our time. Let?s change that?one person at a time!

Connect with Don!

LinkedIn, Flipboard, Twitter, Snapchat

Or, just Google me?I?m everywhere

Send Don an email

18