Windows 10: Error in "get data from web in excel

Hi,

we are trying to import a website data into excel to get the real time report based on it.

we are getting error in web view section saying that "The Highlighting is disabled because this page uses internet explorer's compatibility mode"

so I could not able to get the table content from that web site.

:)

 

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

 

does WP7 excel support or is there future plans to support data validation lists

HI all

just a quick question i was wondering, as the title suggests, if WP7 excel will support data validation lists as i know that the excel in WP6.5 did not. If the new excel does not support data validation lists is it possible to request that this feature be
included in future updates as i find them quite handy.

look forward to a reply

all the best

 

Automatically create process diagrams in Visio from Excel data

Source: Automatically create process diagrams in Visio from Excel data - Office Blogs