How do I open an Excel File in protected view?

Don TomoffFollowDec 19, 2016·2 min readSaveMicrosoft Excel HOW TO Disable Protected View in MS ExcelHow to Disable Protected View default alert in ExcelOverviewBy default, Excel a

How do I open an Excel File in protected view?
Don Tomoff

Don TomoffFollow

Dec 19, 2016·2 min read

Save

Microsoft Excel  HOW TO Disable Protected View in MS Excel

How 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
  • Select Trust Center and click on Trust Center Settings
  • Next, select Protected View and un-check the desired items (all three if you use Outlook for email)

Finally, enjoy opening all of your Excel files without the Protected View nuisance banner! :-)

About Don

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. Lets change thatone person at a time!

Connect with Don!

LinkedIn, Flipboard, Twitter, Snapchat

Or, just Google meIm everywhere

Send Don an email

Video liên quan