407 Proxy Authentication Required / Protocol Violation

Solution

Create a config file named EXCEL.EXE.config in your Office installation folder (for Windows 7 and Office 2010: C:\Program Files (x86)\Microsoft Office\Office14\) with the following contents:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>   
  <system.net>
    <defaultProxy enabled="true" useDefaultCredentials="true">       
      <proxy usesystemdefault="true" bypassonlocal="true"/>
    </defaultProxy>
  </system.net>
</configuration>

Then restart Excel!


See


Get help with this function in the community →