• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data query from web fails to import most hyperlinks

I'm new to Chandoo, but it looks like a great forum. Thanks in advance for your help.


Using Excel 2007, I've set up a data query pointing at the following Japanese newspaper website: http://www.asahi.com/international/list2.html


I selected full HTML formatting in the Web Query Options so that I could get all the hyperlinks to the individual stories, then selected the whole page as my target.


My problem is that out of the 60 story links on that page, only 11 (at this moment) are importing as proper hyperlinks.


Is there any way to tweak the way that Excel imports what's on the webpage, or is this the best that Excel can do?
 
Back
Top