DVD Talk Forum

DVD Talk Forum (https://forum.dvdtalk.com/)
-   Tech Talk (https://forum.dvdtalk.com/tech-talk-10/)
-   -   Excel - External Web Query Not working anymore (https://forum.dvdtalk.com/tech-talk/523615-excel-external-web-query-not-working-anymore.html)

Numes 01-26-08 08:09 PM

Excel - External Web Query Not working anymore
 
If anyone is an excel guru, I could use some help.

For the past few years, I have done an external web query to my Amazon.com wishlist (in the compact mode) so I could easily track my DVD wish list items/prices without having to go to the website and type everything in manually to my spreadsheet. I am using Microsoft Excel 2003.

About 2 months ago, the web query started refreshing much differently than it used to. Now all it shows is this:

Help | View Cart | Your Account | Sell Items | 1-Click Settings

I verified the web query is still pointing to the table with my DVDs and I have tried different options, but I can't seem to get it to load the table anymore.

Any ideas?

Numes 01-26-08 08:14 PM

I just remembered something. This *may* coincide to the time I upgraded to the Internet Explorer 7.0. I'll try reverting back to 6.x.

Anyone know of some discontinuities with web queries with the new IE?

IDrinkMolson 01-26-08 10:22 PM

They probably changed something on their site. And now you've got the wrong table selected.

Just go back to edit query, and see which table is checked. Seems like most of the time for me, I just have to select the whole page.

Numes 01-27-08 09:06 AM


Originally Posted by IDrinkMolson
They probably changed something on their site. And now you've got the wrong table selected.

Just go back to edit query, and see which table is checked. Seems like most of the time for me, I just have to select the whole page.

Well, as I said in my original post, I did verify the web query was still pointing to the correct table.

I went ahead and just selected the whole page, as you mentioned, and that did work. It's a little frustrating because it seems like I should just be able to select that single table. I'll take it, though, that's what hide rows/columns is for.

I also did try reverting back to IE 6.0 and that did not change anything, it must have been a change by Amazon.com.


All times are GMT -5. The time now is 01:22 AM.


Copyright 2021 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.