Acquiring Web Data with Smart Tags
Another useful capability in Excel 2003 is that of bringing information from the Web that is related to the contents of a worksheet cell. The technology that accomplishes this is called Smart Tags.
The clearest example of how Smart Tags work is with stock symbols, the abbreviations of company names on stock market tickers. You can turn on Smart Tags and have Excel look for known stock symbols (such as Microsoft’s stock symbol, MSFT) and connect to a Web site that has information related to that symbol.
To turn on Smart Tags, on the Tools menu, click AutoCorrect Options to display the AutoCorrect dialog box. In the AutoCorrect dialog box, click the Smart Tags tab to display the Smart Tags tab page.
Select the Label ...
Get Microsoft® Office Excel® 2003 Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
