![]() However, the 'mark of the web' (ie right-click the file, Properties > General and tick 'Unblock') had been removed long ago. I wonder if MS has found another way to try and stop macro-enabled files (that have been downloaded / emailed) from running?!Īs an aside, the offending AddIn had been downloaded over the internet. The protected sheet often has a padlock icon in some versions of Excel. ![]() Each sheet's tab appears along the bottom of Excel. 2 Right-click the tab for the protected sheet. You can usually do this by double-clicking the file's name on your computer. ![]() However, the 'mark of the web' (ie right-click the file, Properties > General and tick 'Unblock') had been removed long ago. Using Microsoft Excel 1 Open the workbook with a protected sheet in Microsoft Excel. These sources include a website, email attachments, and other unsafe locations such as shared drives. But I know this isn't gonna be the case for every AddIn for everyone.Īs an aside, the offending AddIn had been downloaded over the internet. Protected View protects you from malware, viruses, and threats that you can be exposed to when opening Excel files from unknown sources. For more information, see Use policy to manage Trusted Locations. > Trusted Locations in the following Office apps: Access Excel PowerPoint Visio Word Policies are available to manage Trusted Locations for each of these Office apps. If you can identify a specific AddIn (or I guess could be multiple AddIns) and opt not to automatically load it/them when Excel starts then I think this is likely to be a better solution than disabling Protected View (no security risk). You can view the list of Trusted Locations by going to File > Options > Trust Center > Trust Center Settings. Uncheck the first 3 options from the right panel and hit Ok. In my case, I wasn't really using the offending AddIn so I have left it that it does not load automatically when Excel starts and so I now do not get the message. Open Trust Center > Trust Center Settings > Protected View. I went through the list of AddIns (in Excel 365, see: File > Options > Add-ins > Manage > Excel Add-ins > Go) and unticked/unchecked each one individually to find the offending AddIn. In my case, the offending file that causes the message to appear when Excel starts is an AddIn that is being automatically loaded when Excel starts. Once you verified the excel file then you can click on Enable. The problem may be related to an update from Microsoft as it is being reported by users on other sites. Using protected view you can read an excel file and see its contents whether it is safe or not.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |