XL2002: Embedded Smart Tags Missing After Save and Reopen (293374)

CAUSE

The behavior occurs when the following conditions are true:

You save the workbook in a format that does not support smart tags.

-and-
You open the workbook on a computer that does not have the smart tag recognizer enabled or installed.

The following formats do not support embedded smart tags:

Microsoft Excel 5.0/95 Workbook
Microsoft Excel 4.0 Workbook
Microsoft Excel 4.0 Worksheet
Microsoft Excel 3.0 Worksheet
Microsoft Excel 2.1 Worksheet
Symbolic Link (SYLK)
All text (.txt) formats, including formatted text (.prn)
All Comma Separated Value (.csv) formats
All Lotus 1-2-3 (.wk*) formats
All DBASE (.dbf) formats
Quattro Pro/DOS (.wq1)
Data Interchange Format (.dif)

RESOLUTION

To work around this behavior, use the appropriate method for your situation.

Method 1

Save the workbook in one of the following formats, which all support smart tags:

Microsoft Excel Workbook
Microsoft Excel 97-2002 & 5.0/95 Workbook
Web Page
Web Archive
XML Spreadsheet

Method 2

To reapply the smart tags, follow these steps on a computer where the smart tag recognizer is installed:

Open the workbook.
On the Tools menu, click AutoCorrect Options.
On the Smart Tags tab, click to select the Label data with smart tags check box.
Click to select the Embed smart tags in this workbook check box.
Click Check Workbook.
On the File menu, click Save As.
In the Save as type list, click one of the file formats listed in Method 1, which all support smart tags.
Click Save.

REFERENCES

For additional information about smart tags in Microsoft Excel, click the article number below to view the article in the Microsoft Knowledge Base:

289148 XL2002: Smart Tag Functionality

For more information about smart tags, click Microsoft Excel Help on the Help menu, type smart tags in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.