Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Troubleshoot smart tags
 

ShowI don't want smart tags in my workbooks.

You can turn off smart tags (smart 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 a smart tag.).

  1. On the Tools menu, click AutoCorrect Options, and then click the Smart Tags tab.

  2. Clear the Embed smart tags in this workbook check box.

  3. Close and reopen the workbook.

You can also hide all smart tags in a workbook.

  1. On the Tools menu, click AutoCorrect Options, and then click the Smart Tags tab.

  2. In the Show smart tags as box, click None.

ShowI turned off smart tags, but they still show up in my workbooks.

You may have copied text containing a smart tag (smart 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 a smart tag.) from another document into your workbook, or smart tags may have been recognized in a document opened on someone else's computer.

To delete the smart tags:

  1. On the Tools menu, click AutoCorrect Options, and then click the Smart Tags tab.

  2. Clear the Embed smart tags in this workbook check box.
  3. Close and reopen the workbook.

To remove individual smart tags as they occur:

  1. Move the insertion point over the text until Smart Tag Actions Button image appears.

  2. Click the arrow next to Smart Tag Actions Button image, and then click Remove this Smart Tag.

ShowI'd like to use smart tags, but I don't want purple triangles on my worksheet.

You can hide the purple triangles and still use the smart tags (smart 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 a smart tag.) feature.

  1. On the Tools menu, click AutoCorrect Options, and then click the Smart Tag tab.

  2. In the Show smart tags as list, click Button Only.

  3. Move the insertion point over the text that might be recognized as a smart tag, such as a financial symbol.
  4. Click the arrow next to Smart Tag Actions Button image. You can select an action, even though the purple triangle is absent.

ShowMy workbook file size is larger when I include smart tags in my workbook.

Smart tags (smart 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 a smart tag.) increase the file size. When size is a concern, turn off the option to embed and save smart tags.

  1. On the Tools menu, click AutoCorrect Options, and then click the Smart Tag tab.

  2. Clear the Embed smart tags in this workbook check box.

Smart tags aren't available

ShowI don't see any smart tags in my workbook.

  1. On the Tools menu, click AutoCorrect Options, and then click the Smart Tag tab.
  2. Select the Label data with smart tags check box.
  3. In the Show smart tags as list, make sure that either Indicator and Button or Button Only are selected.

ShowI don't see smart tags when I type a person's name.

Microsoft Excel recognizes names as smart tags (smart 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 a smart tag.) only if you've recently sent the person e-mail.

Saving smart tags

ShowSome smart tags are lost when I save my worksheet as a Web page.

© 2009 Microsoft Corporation. All rights reserved.