Click add new locations at the bottom and browse to the location you would like to add to the trusted locations list. It's possible the person who sent you the document used a cloud font, which is a font that doesn't ship with Windows or Office but which must be downloaded from the Internet the first time it's used. After installinf office 2010, my excel default will Excel 2010, in this time only it falls to open the file and getting run time error. Disable the option to enable it for Outlook attachments. File block settings were turned off.
Unless you need to edit, it's safer to stay in Protected View. Not sure why it continues to try and open it in protected view. I guess I will just have to keep this disabled. This setting opens all Office documents in a read-only state and you need to click a button before you can edit the document. But when i do it programmetically am getting run time error as i mentioned in my first posting.
Click the File tab in the upper left corner. Also you may find a lot of similar forum threads: Here is what the latter states: According to this article for security reasons Microsoft has introduced this from Office 2010 onwards, and there is no other way to do this other than setting the folder as a trusted location. Any other suggestions on how to solve this? But I am looking for a solution that will allow me to continue to open outlook attachments in protected view as it is designed. Click to participate the survey. Dear Eugene and George, Thanks for your reply, as per the informations said by you both i have tried, but moving the file to some trusted location means that wont be sounds good because already i know this method that moving file to trusted location and then processing but this method not a proper one for processing and if the file is really harmfull to computer means that time this error is thrown means fine but even for trusted files this error is thrown that sound not good.
To change the Protected view setting, you need to make the change in each Office application. Disable the Open Save dialog Note: I recommend making this change only for the document types you open often. Why can't I exit Protected View? Once you check or un-check the settings you want you can close the windows. These steps can be applied for Excel 2010, 2013 and 2016. Hi Sathish, As Eugene mentioned, this is a known issue in Office 2010.
Now in the right panel of registry editor, you can see three values. Is there anyway to disable all of the protected view options from ever running? With protected view turned off the files open without a problem. I can open files I created locally, but cannot open any file received by email. Then save the sheet re-open the sheet it should now open out of protected view. Note: If Word is unable to find any compatible fonts to substitute you might see black boxes where the text should be. In order to enable editing on iPad Excel it said i needed to convert the file. Note: There is no Protected View item in the Trust Center dialog in Excel 2007.
How it works: When an emailed or downloaded document is opened, a red band appears at the top of the document to alert the user that the document is in protected view and cannot be edited. How do I use Protected View with a screen reader? Included in this article Why is my file opening in Protected View? It's pretty obvious when you're in there. Resolution To disable Protected View in Excel, follow the steps in this section. It would be great if anyone could help me. We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Am not developing Macro, its windows application using vb.
Modify Safe Locations To add more locations that are marked as safe for Protected View go back to the Trust Center Settings and click Trusted locations on the left. Recently it seems I can not open any excel or word files in protected view. Administrators will be able to control whether all email attachments or only those from outside their Exchange network use Protected view. When Word, Excel, or PowerPoint opens the file and sees this marker it knows to open the file within Protected View and the user sees the red bar. Before you ask I have saved the file from my email to a folder within my documents. Unless you need to edit, it's safer to stay in Protected View. Excel opens the Protect Structure and Windows dialog box, where the Structure check box is selected by default.
If the file seems suspicious, close the file and delete it from your computer. We recommend you only edit the document if you trust its contents. Thanks for the attempt to dig into it. You may want to notify the sender of the virus. For more information, please refer to. Not sure what or why this happened. Just for your edification I've included links to three screenshots.
The virus has been cleaned. There is also, in Trust Center Settings, a Macro Setting that you can use to Enable All Macros by default. An updated version, which is compatible with Protected View, may be needed. I actually was able to open the file in excel on my iPad through Dropbox and the file opened. What Office file types can cause file-validation errors? Now I can also open this file from my laptop on Excel. I then uninstalled and reinstalled Office 365 Pro Plus, that did not help either.