Tuesday 27 August 2013

Microsoft Office 2013 - Error opening word and excel files that have been downloaded or sent to you as attachments.


How to fix an error opening word and excel files that have been downloaded or sent to you as attachments in Microsoft Office 2013

 Below: Error message
 image thumb How to remove protected view from Office 2013 when downloading documents from the web

The message that has nothing to do with the actual problem, and the problem is actually a Microsoft feature, as often is:

- Office now has a  "protected-mode" feature, which prevents office apps from doing certain things under certain conditions.
- One of them is to stop excel / word from opening attachments coming from outlook.

Click the Microsoft Office ButtonButton image, and then click Word Options. or Excel  depending on what you having a problem with.
 image thumb2 How to remove protected view from Office 2013 when downloading documents from the web 

Below: Click Trust Center, and then click Trust Center Settings. image thumb3 How to remove protected view from Office 2013 when downloading documents from the web 

Below: Click the "Protected View"  in the left menu and untick all 3  check boxes on the right.
'
image thumb4 How to remove protected view from Office 2013 when downloading documents from the web

Save and voila, suddenly  word / excel can open all your files and has absolutely no problems with your gigs of free memory.
Thanks to the brilliant minds who conceived such an awkward feature with awkward error messages and ultra-deep menu options to clear - and of course no simple help. LOL