Unable to Import Data from web in Excel 2016

%3CLINGO-SUB%20id%3D%22lingo-sub-1312911%22%20slang%3D%22en-US%22%3EUnable%20to%20Import%20Data%20from%20web%20in%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1312911%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20getting%20following%20error%20message%2Cwhen%20i%20am%20trying%20to%20import%20data%20from%20web%20in%20Excel%202016%26nbsp%3B%3C%2FP%3E%3CP%3E%22DataSource.Error%3A%20The%20request%20was%20aborted%3A%20Could%20not%20create%20SSL%2FTLS%20secure%20channel.%3CBR%20%2F%3EDetails%3A%22%3CBR%20%2F%3EAny%20help%20in%20this%20regard%20will%20be%20highly%20appreciated.%20I%20am%20using%20windows%208.%3C%2FP%3E%3CP%3EReally%20stuck%20up%20with%20this%20from%20couple%20of%20days.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1312911%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1313173%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20Import%20Data%20from%20web%20in%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1313173%22%20slang%3D%22en-US%22%3EWhich%20URL%20are%20you%20trying%20to%20import%20from%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1313424%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20Import%20Data%20from%20web%20in%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1313424%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3CSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Fwww1.nseindia.com%2Flive_market%2FdynaContent%2Flive_watch%2Fequities_stock_watch.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww1.nseindia.com%2Flive_market%2FdynaContent%2Flive_watch%2Fequities_stock_watch.htm%3C%2FA%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3Ethis%26nbsp%3BIs%20the%20link%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1313597%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20Import%20Data%20from%20web%20in%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1313597%22%20slang%3D%22en-US%22%3EI%20was%20unable%20to%20get%20that%20link%20into%20Excel%20as%20well.%20Likely%20the%20web%20page%20contains%20scripting%20Excel%20is%20unable%20to%20process.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1314774%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20Import%20Data%20from%20web%20in%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1314774%22%20slang%3D%22en-US%22%3E%3CP%3EI%20was%20getting%20following%20message%2C%20when%20i%20am%20trying%20to%26nbsp%3B%20update%20data%20from%3CA%20href%3D%22https%3A%2F%2Fwww.timeanddate.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.timeanddate.com%2F%3C%2FA%3E%26nbsp%3Bwebsite%20.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPic1%2C2%2C3%20are%20when%20i%20tried%20importing%20directly.%20and%20pic4%20wheni%20tried%20to%20import%20using%20power%20query%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello 

I am getting following error message,when i am trying to import data from web in Excel 2016 

"DataSource.Error: The request was aborted: Could not create SSL/TLS secure channel.
Details:"
Any help in this regard will be highly appreciated. I am using windows 8.

Really stuck up with this from couple of days.

4 Replies
Highlighted
Which URL are you trying to import from?
Highlighted
I was unable to get that link into Excel as well. Likely the web page contains scripting Excel is unable to process.
Highlighted

I was getting following message, when i am trying to  update data fromhttps://www.timeanddate.com/ website . @Jan Karel Pieterse 

 

Pic1,2,3 are when i tried importing directly. and pic4 wheni tried to import using power query