Remove Protected View Completely.
This is a registry hack and ensure that the user doing this has complete mastery over Windows registry.
Go to regedit and add this key: HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Security\FileValidation
Add: “EnableOnLoad”=dword:00000000
Source: https://social.technet.microsoft.com/Forums/lync/en-US/0fdf86d5-4cfb-480c-b672-6762f77112b9/completely-disable-protected-view-in-excel-2010?forum=excel
This is a registry hack and ensure that the user doing this has complete mastery over Windows registry.
Go to regedit and add this key: HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Security\FileValidation
Add: “EnableOnLoad”=dword:00000000
Source: https://social.technet.microsoft.com/Forums/lync/en-US/0fdf86d5-4cfb-480c-b672-6762f77112b9/completely-disable-protected-view-in-excel-2010?forum=excel
