New
#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.
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