Excel 2003 - Invalid Web Query

[ryDen]

Hi,

A friend of mine had an excel spreadsheet had included a web query from his company intranet site. It was working until he was upgraded from Office XP to Office 2003. Now, when he tries to refresh the query, it prompts the message "The file could not be accessed. Try the following...", and an "Invalid Web Query" message. However, when via the "Edit Web Query", the page can be seen fine. The url is something like this:

http://server:portno/reports/rwservlet?param1=1&param2=2&param3=3.

The page is trying to connect to an oracle database.

From IE, the page runs just fine with the parameters. same for the previous version of Excel. What could be the error here?

Regards,
Russ

 

[SkipVought]

Hi,

When you get the error, can you navigate to the correct url?

Otherwise, just do a new web query on a new sheet -- data/get external data/new web query...

Skip,

_[red][/red]

 

[ryDen]

Hi,

I can get to the url just fine via IE. Weird thing is when I edit the web query, or make a web query, it all turns up fine in the "preview" window from the "Edit Query" dialog. And when I do an import, the query starts refreshing in the worksheet, and the error comes up again.

I'll try again and see how it goes. Thanks anyway.

Regards,
Russ

 

[rmoster]

Did you ever resolve this issue? I'm having the same problem with a simple web site:

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

Works fine, but:

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

shows up fine in the New Web Query dialog, but I get an error when I try to import.

Thanks in advance for any help!

 

[rmoster]

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....don't understand it, but now it works.