EXCEL 2016 script error when getting external (web) data


  1. Posts : 11,180
    Windows / Linux : Arch Linux
       #1

    EXCEL 2016 script error when getting external (web) data


    Hi there

    Trying to download data from web into a spreadsheet I keep getting Script Error. This worked perfectly in EXCEL 2010 (and still does). Get external data -->web

    The query simply takes the components of the London FTSE 100 (like the Dow jones / S&P) and downloads into a spreadsheet -- all text so no complicated conversions or formulae.

    Any ideas -- did I install Office 2016 missing some option.

    I use this type of data gathering quite a lot so this is a very annoying problem.
    EXCEL 2016 script error when getting external (web) data-excel.png

    as an aside I notice that the web access via EXCEL is still IE based rather than using Edge !!!! so maybe even Ms doesn't know how its own products are supposed to integrate with Edge yet !!!!

    Cheers
    jimbo
      My Computer


  2. Posts : 1
    Windows 10
       #2

    I know this post is over a year old but I too am having the SAME EXACT problem with Excel 2016 running in Windows 10. I also use this frequently and never had an issue before (working on a new computer now). Do you still experience this issue?

    Thanks.
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 17:02.
Find Us




Windows 10 Forums