Page 289 - Excel Workbook for Dummies

29_798452 ch20.qxp 3/13/06 7:44 PM Page 272
272 Part VI: Excel and the Web

12. Accept the suggested filename, 3-mo, 1-yr, 3-yr Top Mutual Fund.iqy, as the name
for this Web query and then select the Save button.
By saving your Web query in an .iqy file (Internet query), you make it possible to
rerun the query with updated data at any later time simply by choosing Data➪
Import External Data➪Import Data and then selecting query name (3-mo, 1-yr,
3-yr Top Mutual Fund.iqy in this case) in the Select Data Source dialog box before
selecting the Open button.
13. Click the Close button in the upper-right corner of the Edit Web Query dialog
box.

14. Save your Web query data in a new workbook named Solved20-7.xls in your
Chapter 20 folder in the My Practice Spreadsheets folder on your hard disk and
then close the workbook as you exit Excel.

Query Parameters Cancel Refresh
Edit Query Refresh Status

Figure 20-3:
Worksheet
with data
imported
from the
Yahoo!
Mutual
Fund Top
Performers
Web page.

Data Range Properties Refresh All

Refresh Data