Excel Microsoft 365 cant connect to data from web

Ellen Cristina 31 Reputation points
2020-12-11T22:16:49.847+00:00

Hi!

When I try to get data from web in Excel with a Sharepoint URL, I got a SSL/TLS error. I'm using Microsoft Business Premium and the most updated Excel for Microsoft 365 version.

I follow this steps: Data > Get data > From web, then paste the URL and try to authentic with my organizationail login.... then get the error:

"Could not establish a trust relationship for the SSL/TLS secure channel".

Days ago, these steps just worked perfect... My SSL/TLS protocolos are update. Microsoft .NET Framework too btw. No proxy.

47468-whatsapp-image-2020-12-10-at-123220-3.jpeg

47541-whatsapp-image-2020-12-10-at-123220-2.jpeg

47415-whatsapp-image-2020-12-10-at-123220-1.jpeg

47437-whatsapp-image-2020-12-10-at-123220.jpeg

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,714 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,221 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,646 questions
0 comments
Accepted answer
  1. Ian Campbell 81 Reputation points
    2020-12-14T11:08:44.773+00:00

    Thanks,

    I'll try that. Ours affects multiple users, but not all.
    BTW
    I have just found a workaround,
    If you go to
    Excel > Data > Get Data > Query Options > Global > Security
    and untick 'Enable certificate revocation check'

    it works, but obviously not ideal.
    Seems strange as the only certs involved here should be *sharepoint.com and login.microsoft.net

    I'll go through the certificate stuff above and see if I can find more info

    Excel version 2011 (Build 13426.20308 Click-to-Run)

    1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Allen Xu_MSFT 13,776 Reputation points
    2020-12-14T10:03:55.69+00:00

    Hi @Ellen Cristina ,

    Does this problem occur to one user or multiple users?

    Firstly, please try to clear Office Cache: Close all Office applications -> Clear all the files located under %systemDrive%\Users\%userprofile%\AppData\Local\Microsoft\Office\15.0\OfficeFileCache\

    If the issue still exists, please try the following steps:
    1.First we have to retrieve the certificates required. To get the needed certificates go to https://login.microsoftonline.com with the Microsoft Internet Explorer. Click to the certificate item next to the address bar and open the certificate with “View certificates” link.
    47922-1.png

    2.Chose the root certificate from the “Certification Path” tab and click “View Certificate”.
    47923-2.png

    3.In the upcoming certificate window chose “Details” tab. There you can copy the certificate to a file.
    47878-3.png

    4.Save the file to a local folder on your computer. Afterwards login to your SharePoint Online Workspace (https://yourtenant.sharepoint.com/) and repeat the steps for the certificate of this site.

    5.open the MMC console, and Add certificate using File -> Add -> Remove Snap-In:
    47879-4.png
    Here you will prompt to select the location, where you can select the Computer Account and then Local Computer.

    6.Import your saved certificate.
    47917-5.png

    I hope this information has been useful, please let me know if you still need assistance.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
  2. Ian Campbell 81 Reputation points
    2020-12-14T09:47:11.25+00:00

    We have the same issue here.
    Has worked for months, then we ran into this problem last week

    0 comments