Troubleshoot smart tags

Microsoft Office Excel 2003

previous page next page

You can turn off 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.

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 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 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 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 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.

  • Smart tags can only be viewed using Microsoft Internet Explorer 5 or later.

  • Smart tags are not saved if the user chooses to publish to a Web page instead of saving the workbook as a Web page.

previous page start next page