May 29 2018
12:34 PM
- last edited on
Jul 25 2018
10:02 AM
by
TechCommunityAP
May 29 2018
12:34 PM
- last edited on
Jul 25 2018
10:02 AM
by
TechCommunityAP
With ActiveSheet.QueryTables.Add(Connection:= "URL;https://www.msn.com/en-us/money/stockdetails/fi-126.1.SFL.NYS?symbol=SFL&form=PRFIMQ", Destination:=Range("$A$1"))
Above fails to bring data into worksheet. Have used this for years.
"Unable to open ..." and the web address and " ..... Cannot download the information you requested"
Apr 02 2020 07:07 PM
I am having the same problem with multiple web queries that I have used for years. They have long connection strings that are saved in .iqy files. After I upgraded to Microsoft Office 365 they continued to work for a while but then later started throwing the "Cannot download the information you requested" error. It has completely halted my work. I prefer not to attempt a downgrade back to my old version of Excel. The spreadsheets still work fine on another computer with the older version of Excel. Is there a fix to this issue? Is it a security setting?