OData, Microsoft Excel 2013 & our TLS 1.0 Deprecation
As Convercent continues to ensure up-to-date and advanced security policies and measures are in place to secure your data, we are making a change to the version of TLS we support. On July 12, 2019, we will be deprecating support for TLS 1.0, which may impact your ability to use Excel 2013 to run OData reports/pulls (2013 referring to the version of Excel or Office installed on your system).
To determine if you are on the Microsoft 2013 Office suite that has Excel with it, when in the Excel program perform the following steps:
- Click the File tab in the ribbon.
- Then click Account.
- On the right, you should see an About button.
- The About screen will display your information and show whether you are on Office 2013, Office 2016, or Office 365.
If you see Office 2016, or Office 365, you do not need to take any action as these already utilize the more up-to-date TLS version of 1.1 or 1.2 for data transfer security protocols.
If you see Office 2013, please continue reading.
**We strongly recommend updating your Microsoft Office suite to the latest version to prevent the need for the workaround solution provided below. Editing the registry can be dangerous if you are not familiar with the edits you are making or are unsure if you are in the right location. The script provided here helps to minimize the risk, however, we also recommend some extra safety measures of backing up your registry using the steps in the Microsoft article here.
We have diligently been working to find solid resolutions to this change to provide the as minimal of an impact to you as possible. There is a small change to your system that is needing to occur, and we have created the attached script below to help minimize the work you need to perform. Below are the steps for using this file:
- Download the attached TLS.zip file to your computer and double-click the TLS.zip file to extract it
- Double-click the TLS file to open and execute the script to modify the registry entry for your system
- On the User Account Control prompt that appears, click YES to continue
- You will then be prompted with a Registry Editor information alert, which you will need to click Yes to continue forward with this fix.
- On the second Registry Editor window, you should see a notice that it was Successfully added to the registry", click OK to close the window.