Troubleshoot smart tags

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.

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

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

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 . You can select an action, even though the purple triangle is absent.

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.

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.

Microsoft Excel recognizes names as smart tags only if you've recently sent the person e-mail.

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