Getting Continuously Refreshed Data from a Web Site in Excel 2002 & 2003

 

Excel 2002 and Excel 2003 enables selecting an exact data table on a Web site, and importing and refreshing only the needed data.

To import and refresh information from a Web site:

1. Open Excel 2002 or Excel 2003, and from the Data menu, select Import External Data, and then New Web Query.
2. In the Address box of the New Web Query dialog box, type or paste the address of the Internet site. For example, open the site www.bloomberg.com, which includes a table of various currency exchange rates. The address of the page containing the table of currency exchange rates is http://www.bloomberg.com/markets/index.html.
3. In the dialog box, notice the Web page. Click the small arrow in the upper left-hand corner of the table to select only the data table.
4. Click Import.
5. To save the query, click Properties in the Import Data dialog box.
6. In the External Data Range Properties dialog box, enter the query name in the Name box, select the Save Query definition checkbox, and then click OK.
7. In the Import Data dialog box, click OK to import.

To refresh the Internet data (the Web site does not have to be open):

1. Select the cell in the sheet containing the data.
2. From the Data menu, select Refresh Data.
OR
Display the External Data toolbar and click the Refresh Data icon. To display the External Data toolbar, select one of the toolbars, right-click and select External Data, and click OK.

To automatically refresh the Internet data:

1. On the External Data toolbar, click the Data Range Properties icon.
2. Select the Refresh every option, and set the number of minutes between each refresh action.
3. Select the Refresh data on file open checkbox to automatically refresh the data when the file is opened.

To run a saved query:
1. From the Data menu, select Import External Data, and then Import Data.
2. Select the saved query , and click Open.
Screenshot // Getting Continuously Refreshed Data from a Web Site in Excel 2002 & 2003
Getting Continuously Refreshed Data from a Web Site in Excel 2002 & 2003Getting Continuously Refreshed Data from a Web Site in Excel 2002 & 2003



2 thoughts on “Getting Continuously Refreshed Data from a Web Site in Excel 2002 & 2003

  1. How could something as original, useful and easy as this one be not known till now. This is an excellent tip and will be very useful in my day-to-day work. I can’t thank you enought.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>