Data Import & Export

Fix Excel 2016 Web Query SSL/TLS Trust Errors

Phi Hung VoPhi Hung Vo Nov 22, 2026 868 views

Question details

The user needs Excel 2016 to retrieve data from an internal website without an SSL/TLS trust error.

Fix Excel 2016 Web Query SSL/TLS Trust Errors
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.
Before you start

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.

Solution 1Recommended

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.

1
Inspect the site certificate

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.

2
Request a server-side review

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.

3
Check TLS compatibility

Ask the administrator to review the server's supported TLS protocols and the client and Office configuration used by Excel 2016.

4
Retry the web query

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.

Have an administrator check the site's certificate and TLS configuration
Browser access is not conclusive: A site opening in a browser does not guarantee that Excel's connection will trust the same certificate chain or use a compatible TLS configuration.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLS and XLSX filesWork with spreadsheet data in a familiar interfaceUse a free, lightweight Office alternativeMove existing spreadsheet files into WPS Office
microsoft office alternative - wps office

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.