![]() |
Data from Web Excel 2007
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/ener...eet-crude.html I did the following steps: from the Ribbon DATA FROM WEB http://www.cmegroup.com/trading/ener...eet-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! |
All times are GMT +1. The time now is 01:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com