Excel: Web Queries Fail with Web 2.0

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Problem: The previous editions of this book showed how to pull stock quotes from the web using Data, From Web. This worked great every five minutes for a couple years, but then it stopped working.

Strategy: The old web query technology was designed to get a table from a static HTML page. Now, with javascript and flash and HTML5, the web query is often not seeing any tables on the page.

If you need to get data from the web, download the free Power Query add-in and use the From Web option in Power Query.

For more resources for Microsoft Excel