Earlier we saw How to do calculations with Live Data from Web in Excel 2007? This functionality is very useful to retrieve any table of date from any web site which are updated very frequently. Microsoft Research has released an advanced plugin for Excel 2007 (Excel 2007 Web Data Add-In) which allows you not only import data tables but also any particular cell. It also allows you to train Excel about the data you usually import. Simply put, it gives advanced features to Excel while handling the live data from web.
After installing this add-in for Excel, when you go to Data tab and Click From Web, you will cell From Web (Advanced Mode) enabled.
How to use advanced mode to get live data from web in Excel 2007?
The best of all, when you click From Web (Advanced Mode), you will see an embedded Video Demo which explains this new feature.
On top of the window of New Web Query, enter the web address and press Enter.
Lets say we are tracking information from Google Finance on Technology. Browse to the page you want to collect data and then click Capture Data on top of the window. See image below for more information.
When you click Capture Data, a sheet will be embedded at the bottom of the window. Now double click any field you see on the page to collect data. It need not be in any table format. Adjust the cells in the bottom portion and collect as much as data you want.
When you double click and choose, those fields in the web page will be highlighted with the corresponding cell reference.
After selecting a few rows of information, you want to follow the similar pattern through the rest of the page, choose the option Select Similar.
The cells which are selected through this feature will be highlighted in green color. Now click Import at the bottom of the window to insert these collected data in the Excel Sheet.
The features like setting the excel to refresh automatically within a given duration and others are similar to what’s been described earlier. Read How to do calculations with Live Data from Web in Excel 2007?