I started having the issue you described when downloading reports via the Internet. The following code used to work in Excel 2003 but not in Excel 2010. Now on the left column click Protected View and uncheck any documents you would like to open automatically with Protected View disabled. If you know the file is from a trustworthy source, and you want to edit, save, or print the file, then you can exit Protected View. To ease suspicion, you can call or email the person who sent you the file to confirm. I make all settings from Trust Center at both sender and receiver user of the file. Then save the sheet re-open the sheet it should now open out of protected view.
Then click Trust Center Settings. Step 1: Go to file location in Registry Editor you want to disable Protected View for. An example of an unsafe location is your Temporary Internet Files folder. An updated version, which is compatible with Protected View, may be needed. After many frustrating hours, I was able to get Excel to open them with a bit of a work around.
Otherwise the enable editing is skipped and everyone is happy. I managed to Google this article and quickly implement the changes. This message means that editing the file could be dangerous. Disable Protected View for Specific Documents To get to the protected view options, open Microsoft Word 2010 and then go to file and options. From the list, click Open in Protected View. I am currently running Excel 2010 Standard.
When i run it, it works fine, but when someone else runs it, it show an error. If either of these Trust Center settings are changed, you need to be very careful about the Excel files that get opened. Screen Resolution 1600 x 900. There are several reasons why documents are opened in read-only mode. I accidentally clicked something which changed my mail view to a list view. Microsoft Office I know it is starter, but I still believe there is a view option somewhere -at least I hope-! Unless you trust this person and want to continue collaborating with them, it is safer to stay in Protected View.
Hope this tip is helpful and saves you some time! When you encounter the message in Protected View that states This file was opened in Protected View. Click Protected View on the left column and uncheck settings according to the source of excel file, to disable Protected View for documents. A problem was detected with my file Office found a problem with your file and it might be a security risk. You will see a red bar accross the top of the sheet. How do I use Protected View with a screen reader? On the right hand side of the is an X click that to close then enable editing also. I think it is important information: I using windows 10 This issue has more to do with Excel 2010 than anything else.
I dont have my protection up at all, and they have I dont know why, but if the excel file which i get from the report manager has that type of protection Enable editing button it just doesnt work. When there are inconsistencies between the file and the schema, the file will fail validation and will open in Protected View. There are several ways to get around this issue: Recommended The simplest and most secure method to get around this issue is to simply click the Enable Editing button, on a per-document basis, when you open an Excel or other Microsoft office file that has been downloaded. When you open one of these files you will get a warning message. After you leave Protected View, you've effectively remove read only, and the file becomes a. So not only was it removed from email, to prevent the issue of opening in protected view because it was from Outlook. With Excel 2010 I am unable to open the file, even though I've unchecked all of the Protected View settings.
Also, i tried the tip you said here, but it then shows a bug in the 2nd line of your code Application. What happens to add-ins in Protected View?. Excel won't open my file when I double-click on it. Disable Protected View from Registry Like most options in Windows there is a way to disable these settings via the registry too. I work a lot in Excel and I receive invoices created in Excel every month from a trusted source. Suddenly, our boat was boarded by Somali pirates and we were taken hostage. I hope that someday, we the users will get rid of it as we have no fault on Windows being popular.
Protected View gives you warnings about possible threats or problems with your file such as corrupt or broken code, computer viruses, worms and other types of malware. If you don't mind send me a copy of just the macros to and I'll probably have a better chance cracking the issue. But we recommend that you avoid editing a file that seems suspicious. Editing it may harm your computer. 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. I have complete trust in my Norton software to handle all these types of issues. Step 1 -- Disable Protected View for Each Document Some documents, such as those which have been downloaded from the internet, start in protected view.