Yahoo web queries failing again

[Alan]

I have an XLS that loads the daily earnings calendar from
Yahoo, at URLs like
http://biz.yahoo.com/research/earncal/20031118.html

Today, it started failing, spewing the familiar "The
Internet site reports that a connection was established
but the data is not available."

It works fine in IE6. I looked at the query and the
result with NetMon, both when requested from IE and from
Excel, and there's nothing immediately obvious, other
than that the response to the Excel query is shorter, but
that may just have to do with what ads gets served with
the results.

 

[Don Guillett]

xl version?

I just tried it from HERE with no problem. xp home, ie6
If you want, send your workbook to ME, not the list and I will have a look.
I have NO idea what NetMon is?

 

[Alan]

Thanks for your quick reply. Please see below:

-----Original Message-----
xl version?

Sorry.
XL2002 10.4524.4219 SP-2
IE6 6.0.2800.1106.xpsp2.030422-1633
WinXPPro 5.1.2600 SP1 Build 2600 (5.1.2600.1106
(xpsp1.020828-1920))

IE6 and WinXPPro have all the latest patches as of 11/16.

I just tried it from HERE with no problem. xp home, ie6
If you want, send your workbook to ME, not the list and

I will have a look.

Here's the steps that are used to reproduce it (for the
benefit of others):

- Create new workbook.
- Choose Data->Import External Data->New Web Query
- Put http://biz.yahoo.com/research/earncal/20031119.html
in the Address box. Push Go button.
- Click on the third yellow arrow (where it says Earnings
Announcements for Wednesday..." to turn it green.
- Push Import button.
- Push OK button to import into existing worksheet at A1.
- It says "20031119: Getting Data ..." at A1 and then the
error dialog.

I have NO idea what NetMon is?

Microsoft's network sniffer.

Also, upon further examination, I found that the results
returned were of almost exactly the same length when I
looked at only the frames that came from Yahoo.