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.
Click image for larger version. 

Name:	excel.png 
Views:	1 
Size:	53.5 KB 
ID:	55882

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 !!!!