Data from Web Excel 2007

H

hawaiiham2000

I am trying to import a table from a website into Excel that automatically
refreshes and can be used in formulas. I was successful in doing this with a
currency exchange website, but am having difficulty with this website in
particular:

http://www.cmegroup.com/trading/energy/crude-oil/light-sweet-crude.html

I did the following steps:
from the Ribbon

DATA
FROM WEB
http://www.cmegroup.com/trading/energy/crude-oil/light-sweet-crude.html
CLICKED FIRST YELLOW ARROW TO THE LEFT AND ABOVE "MONTH"
OPTIONS - FULL HTML FORMATTING
IMPORT
PROPERTIES
OVERWRITE EXISTING CELLS WITH NEW DATA...
FILL DOWN FORMULAS IN COLUMNS...
OK
OK

Part of the table is inserted, but the numbers do not display.

Any hints?
Thanks!
 

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

Top