I don't knoweither, but I wouldn't be surprized. When you setup the query
from the worksheet menu a IE application opens up. So there is some sort of
relationship between the two.

"Wes" wrote:

Explorer v8 could be part of the problem ... but I am not sure how Explorer
would impact the way Excel inserts the data into the spreadsheet.



"Joel" wrote:

did yo uupgrade your Internet explorer to version 8.0. It could be the
webbrowser or the webpage may have gotten updated. I 'e been having problems
with queries not returning all the data and had to resort to using VBA code
to extract data from webpages rather than using a query.

"Joel" wrote:

There are 3 options in a query you can edit after you create the query. Not
sure if these will work but they appear to be releated to your problem. the
1st is the default setting

If the number of rows in the data range changes upon refresh

Insert cells for new data, delete unused cells
Insert entire rows for new data, clear unused cells
Overwrite existing cells with new data, clear unused cells


To get to these options in excel 2003 (not sure where they are in 2007)

1) Click any cell in the returned data from the query
2) Go to menu Data - Import External Data - Data Range Properties

the Data Range Properties will only be enabled when you click a cells in the
range of the query. The range of the query can be found by looking in the
Named Ranges by going to menu Insert - Names - Define. Then click on the
name of the query.


"Chris" wrote:

I created an excel spreadsheet that captures prices from the web and what I
want to do is take these prices from the web queries I created and move them
into a workable list. The problem is when the queries are first created and I
hyperlink them into a list, it works great!!!! The problem occurs when a
couple of days later when I refresh, the data becomes skewed and some of the
lines shift. What should be a price is another piece of data from the web
query appears on the link. I have tried developing the queries both dynamic
and non dynamic but both ways I have problems with the data.

Ultimately, what I would like to do is have the queries build once,
hyperlinked into another sheet and then build a pivot table from the results.
If you have any insight or feedback on this, I would be most grateful. Like I
mentioned, if you do not know then I guess this cannot be done.

Best Regards,

Chris