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!
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!