Dec 19, 2016·2 min read
Microsoft Excel HOW TO Disable Protected View in MS Excel
How to Disable Protected View default alert in Excel
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! :-)
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