Excel Web Query - Web Page does not load in explorer but fine in Firefox

Hi guys,

I am trying to pull some live data from a web page and am having trouble with this particular web page. It loads fine in Firefox and Chrome but when I am in Excel and go to Data > Get External Data > From Web and then try to load the web page I get errors. After accepting okay to the errors the web page loads but the live data is just zero (0).

I have attempted to make a .iqy file manually and it returned no data.

The web page is http://www.mtsjewelry.com/
The data I want is at the bottom of the page. See the attached screenshots.

Can anyone advise what I am doing wrong or how to get around this issue so I can get the data, please?


Admin, if this is in the wrong area, I apologise. I could not find a suitable sub forum to place it.

Originally Posted by avk

In excel like this do you want.
plz refer attach file.

Thank you. But i am only after the web page's live data that i drew the arrows to in my screen shot.

I need those three number added into cells g3:g5 and to live update on opening the worksheet like other web queries.

The web page data is not in a table so excels web query is not picking it up and it throws up errors.