Excel 2013 'Protected View'

dealhunter1985 · 2015-11-20 12:06:49

Hi Does anyone know how to turn off the 'Protected View' by default. Its an absolute pain in the butt Everytime I export a document to Excel, Excel opens up with the 'Protected View' enabled thanks

20-11-2015 12:06PM

#1

dealhunter1985

Registered Users, Registered Users 2 Posts: 523 ✭✭✭

Join Date: June 2011

Posts: 471

Hi
Does anyone know how to turn off the 'Protected View' by default.
Its an absolute pain in the butt

Everytime I export a document to Excel, Excel opens up with the 'Protected View' enabled

thanks

0

Comments

#2 20-11-2015 12:08PM

Taltos

Registered Users, Registered Users 2 Posts: 20,830 ✭✭✭✭

Join Date: February 2007

Posts: 19167

http://www.corporatefocus.com/support/how-to-disable-protected-view-in-microsoft-excel

not recommended though...

0
#3 23-11-2015 11:17AM

d31b0y

Registered Users, Registered Users 2 Posts: 2,028 ✭✭✭

Join Date: February 2007

Posts: 1904

As a middle of the road solution, you could add a specific location to the trusted locations in Excel. Any file opened from the trusted location would open in edit mode, afaik. Just be sure to use a specific folder rather than the downloads folder etc.
https://support.office.com/en-us/article/Add-remove-or-change-a-trusted-location-7ee1cdc2-483e-4cbb-bcb3-4e7c67147fb4

0
#4 23-11-2015 04:08PM

dealhunter1985

Registered Users, Registered Users 2 Posts: 523 ✭✭✭

Join Date: June 2011

Posts: 471

thanks for the replies.
I went with Taltos option and it worked a treat.

0