If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

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 1: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 1: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 12:17pm

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 5: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