Problem with web query all of a sudden

**rmoster** · 02-16-2007, 08:21 PM

The following web query was working, now it isn't:

http://finance.yahoo.com/q/hp?s=KO&a...=17&f=2007&g=d

In other words, if I open a new workbook, and select Data/Import External Data/New Web Query, then the New Web Query dialog window comes up. I then type the above line into the Address box and the web page comes up correctly within the New Web Query window. I select the table with all the stock data (it's the table with the column headers that read "Date Open High Low Close Adj Close*") and then I click Import. Then the Import Data dialog window opens and I accept the default location and click OK. Even though the page views correctly within the New Web Query window, I get an error message that reads:

The file could not be accessed. Try one of the following:

. Make sure the specified folder exists.
. Make sure the folder that contains the file is not read-only.
. Make sure the file name does not contain any of the following characters: < > ? [ ] : | or *
. Make sure the file/path name doesn't contain more than 218 characters.

I then click OK in that error dialog and another error dialog appears that says "Invalid Web Query."

This all worked fine the other day...

Any ideas?

**rmoster** · 02-16-2007, 08:46 PM

I'm going to simplify this. The following web query works:

http://finance.yahoo.com/q?s=KO

The following web query doesn't work:

http://finance.yahoo.com/q/hp?s=KO

They both show up OK in the New Web Query, but the latter causes an error upon import.

Could Yahoo! have changed something on its web page to prevent importing through Excel??

(I'm using Windows XP and Excel 2003.)

**rmoster** · 02-17-2007, 02:52 PM

Well, I went into Internet Explorer, deleted everything (browsing history, cookies, temp files, etc.), deleted everything out of the Norton Protected Bin, Emptied the trash, and voila! Everything works again....