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.


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

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.