Get a stock quote

  1. Make sure that smart tags (action tags: Data recognized and labeled as a particular type. For example, a person's name or the name of a recent Microsoft Outlook e-mail message recipient is a type of data that can be recognized and labeled with an action tag.) are turned on.

ShowHow to turn on smart tags

  1. Click the Microsoft Office Button Button image, and then click Excel Options.
  1. Click Proofing, and then click AutoCorrect Options.

The AutoCorrect dialog box appears.

  1. Click the Smart Tags tab, and then select the Label data with smart tags check box.

ShowIssue:    I don’t see any smart tags in the Recognizers list

If you don’t see a list of smart tags in the Recognizers list (on the Smart Tags tab in the AutoCorrect dialog box), the Smart Tags add-in must be installed. To install the add-in, do the following:

  1. On your computer's system disk, locate the following folder:

\Program Files\Common Files\Microsoft Shared\Smart Tag

  1. Run the program SmartTagInstall.exe.

  1. Click OK twice.

  1. Type a recognized U.S. financial symbol (for example, MSFT) in a cell. Be sure to type the symbol in uppercase letters.
  2. Click outside the cell.
  3. Move your mouse pointer over the purple triangle in the lower-right corner of the cell, and then click the arrow next to the Smart Tag Actions Button image button to see a list of options.
  4. Click Insert refreshable stock price.
  5. In the Insert Stock Price dialog box, choose whether to insert the stock price on a new worksheet or in a specific area of your current worksheet.

 Note   The data that is returned might fill a large portion of your worksheet.

 
 
Applies to:
Excel 2007