Invalid Web Query errors.

Y

YellowBird

I am using the External Web Query to retrieve data from several financial
web sites. MSN Money and Yahoo are the most common sites visited.

When using "Refresh All" from the External Data Toolbar, Excel frequently
returns an “Invalid Web Query†error. When the query is edited, many times
there seems to be a disconnect from where the data was originally requested.
The query returns to the correct web page but there is no check next to the
data originally requested or the check has moved to another data area.

As best as I can tell, this error appears to be common when the query looks
at a Yahoo Finance page. I do not seem to have the same issues with MSN
Money’s web page(s)

Any thoughts or insights would be greatly appreciated.

Yellowbird
 
C

cjtwantstoknow

I get the same problem. I suspect Yahoo returns some data that
confuses the web query. I was successful rebuilding the queries in
some instances and the problem went away.
 
Y

YellowBird

With investigation, it seems that Yahoo's info is "dynamically scripted"
which can cause problems. I/we are successful when we "Edit" the Query when
it fails. The best work around is to find static information. Yahoo's is
not.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

download info from a web site to Excel 3
Web Query 2
Problems with Web Query 0
External Web Query 3
Excel Web Query 1
Stock Quotes from Web 1
Web Query Update 0
EXCEL: to retrive data from the web 2

Top