Fix Excel 2016 Web Query SSL/TLS Trust Errors
Question details
The user needs Excel 2016 to retrieve data from an internal website without an SSL/TLS trust error.

- Product
- Microsoft Excel 2016
- Device & OS
- not provided
- Scenario
- The user is importing data from an internal website using Excel's Data from Web feature.
- Observed behavior
- Excel reports that it could not establish a trusted SSL/TLS relationship, although the site opens in other browsers.
Note the exact URL and error message from Excel, and check whether the same URL opens in a browser. Do not include passwords or other credentials when sharing diagnostic details.
Have an administrator check the site's certificate and TLS configuration
Use this approach to investigate common server-side causes of a Web Query trust error.
Open the same HTTPS URL in a browser, select the site information or padlock icon, and view the certificate details. Note the hostname, issuer, and expiration date.
Send the URL and Excel error message to the server or network administrator. Ask them to verify that the certificate matches the hostname, is unexpired, and has a complete chain to a trusted certificate authority.
Ask the administrator to review the server's supported TLS protocols and the client and Office configuration used by Excel 2016.
After the administrator makes any necessary changes, return to Excel's Data tab, open the From Web import command, and try the same URL again.

Escalate persistent Excel Web Query errors to IT
Use this option if the certificate and server TLS checks do not resolve the error.
Work with Excel Files in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar interface for working with existing spreadsheets. It supports common Excel formats for an easier transition, but it does not fix Excel's SSL/TLS trust configuration.

Frequently Asked Questions
Why does the website open in a browser but fail in Excel?
Excel and the browser may use different trust or connection configurations. Ask an administrator to check the certificate chain, hostname, expiration, and TLS compatibility for the exact URL used in Excel.
What certificate details should I send to IT?
Open the HTTPS site in a browser and use the site information or padlock icon to view the certificate. Share the hostname, issuer, expiration date, and Excel's exact error message.
Can an internal certificate authority cause this error?
Yes. If the certificate authority or an intermediate certificate is not trusted by the Excel client, the connection can fail. Ask IT to verify the full certificate chain and the client's trust configuration.
Where do I retry the import after IT makes changes?
In Excel 2016, go to the Data tab and open the From Web import command, then enter the same URL. The command's location can vary with the available query tools.




