Skip to content Skip to sidebar Skip to footer
Home / Excel / Excel 2010 / Excel Web Query / Html Table

Why Is Web Query Not Highlighting My Table In Microsoft Excel 2010?

Post a Comment
I am looking to use Excel's Web Query feature to give users access to constantly changing datasets. Why not ODBC straight to the database? Well, there are several databases on sev

Solution 1:

I compared my code with the code of another webpage where the tables were highlighting properly in Web Query. Through some trial and error, I found the problem.

In the <head> section of my webpage, I had the following meta tag.

<metahttp-equiv="X-UA-Compatible"content="IE=edge" />

Turns out when this is included, the Web Query table selecting option breaks. Based on the disappearing Bootstrap rounded corners, I'm guessing Web Query is using some sort of IE Compatibility Mode, and the above meta tag breaks it.

Excel Web Query Window

Post a Comment for "Why Is Web Query Not Highlighting My Table In Microsoft Excel 2010?"