Configure the settings file for the Excel Add-in to enable connections via a proxy server.
You should have an intermediate to advanced knowledge of XML to adjust the settings file.
If you are not familiar with XML, ask your Tenant Administrator to configure your proxy settings.
When you install the Excel Add-in, a settings file is created in the following location:
To make changes to the proxy settings, open the settings file in Notepad.
For any changes you make to the proxy settings to take effect, ensure that the DefaultProxy setting is set to true:
Add Proxy Settings to the settings file
When you install a Series 4 version of the Excel Add-in, there's no section in the settings file for proxy settings. Previous versions had a section for proxy settings by default.
To adjust the proxy settings in the settings file, use the text as a template. Insert the ProxySettings tags after the Features tags and before the close of ApplicationSettings tags.
<SelectedProxy>Override</SelectedProxy> <!--Can be one of the following: None/Legacy/System/Override -->
<ProxySetting Name="SmoothWall" Address="http://192.168.0.1" Port="800" />
If you've added this text to the default settings file for a Series 4 version of the Excel Add-in, your file displays as below:
Be sure to use the <ProxySettings> tag.
This has changed from Excel series 3 where <ProxySupport> tags are used.
Available proxy settings
Once you've added the text above to your settings file, you can replace the value between the SelectedProxy tags to select different proxy behaviors. The valid values for proxy settings are:
Use the None setting if you do not need to use a proxy.
This is the default behavior if proxy settings have not been configured in the settings file.
Use the Legacy setting to enable Series 4 versions of the Excel Add-in to support your system's proxy server.
This setting attempts to connect you to your system's default URL for proxy servers. To change this URL, see Microsoft WebProxy.GetDefaultProxy Method
Use the System setting as an alternative to the Legacy setting, to enable Series 4 versions of the Excel Add-in to support your system's proxy server.
This setting attempts to connect you to the non-default URL defined for proxy servers in your system. To change this URL, see Microsoft WebProxy.GetProxy(Uri) Method
Use the Override setting to enable the Excel Add-in to support a proxy server of your choice. This setting bypasses your system's proxy server and uses details you provide in the settings file.
To use the Override setting, you need to also provide additional values for the SelectedOverrideProxyName and OverrideProxies tags. An example can be seen in the prior section on this page.
Within OverrideProxies you must define one or more proxies. To define a proxy, you must provide a:
- ProxySetting Name, which you choose and should be logical.
- Address, which must be the http address of the proxy server.
- Port, which must be the port for the proxy server.