Enable Protected View for files originating from the Internet The.Instead, an error message appears for files that Clearing this option doesn’t turn offįile validation. Validation scans file for security problems that can result fromĬhanges in the file structure. Enable Protected View for files that fail validation File.When you open the Excel you will see the web traffic being passed to access the file. If you want to validate this - get a program like Fiddler or Wireshark. What windows is doing is using WebDav in the background to connect to a URL. When you connect to SharePoint by mapped drive it doesn't work like a normal UNC share. You will notice Chrome honors those and most application take configuration from there. The 'Internet Settings' are not just for IE. If your SharePoint site is internal - you should be able to add the URL to intranet zone and achieve the result you are looking for. For Local Intranet this is set to 'Allow'.For Trusted sites this is set to 'prompt'.'Launching applications and unsafe files'

If you look in custom properties you will find the setting

Excel remove protected view