Microsoft Office Tutorials and References
In Depth Information
To Import Data from a Web Source Using a Web Query
2
Double-click MSN MoneyCentral
Investor Stock Quotes to display
the Import Data dialog box
(Figure 2–77).
instructs Excel to
place external data on
current worksheet
Import Data
dialog box
instructs Excel to
place upper-left
corner of external
data in cell A1
OK button
Figure 2–77
3
Click the OK button.
When Excel displays the Enter
Parameter Value dialog box, type
the nine stock symbols aapl t c
cmcsa goog hd ibm mrk s in
the text box.
Enter Parameter
Value dialog box
Click the ‘Use this value/reference
for future refreshes’ check box to
select it (Figure 2–78).
stock symbols
separated by a space
keeps symbols
entered above for
future references
What is the purpose of clicking
the check box?
Once Excel displays the worksheet,
you can refresh the data as often
as you want. To refresh the data
for all the stocks, click the Refresh
All button on the Data tab on
the Ribbon. Because the ‘Use
this value/reference for future
refreshes’ check box was selected,
Excel will continue to use the same
stock symbols each time it refreshes.
OK button
Figure 2–78
 
 
Search JabSto ::




Custom Search