XL2002: Excel Crashes If More Than 65,530 Smart Tags Are on a Worksheet

When you copy a cell that contains a smart tag to another cell, Excel may stop responding (crash), and you receive an error message similar to one of the following.

Microsoft Windows 98, Microsoft Windows 98 Second Edition (SE), or Microsoft Windows Millennium Edition (Me)

Microsoft Windows 2000

The Microsoft Application Error Reporting dialog box is displayed:

This problem occurs if more than 65,530 cells are marked with a smart tag. Microsoft Excel is limited to 65,530 smart tags per worksheet.

To work around this problem, separate the data that you want to recognize into multiple sheets, each of which contains no more than 65,530 recognizable terms per sheet.

A term is any piece of data that one of the installed smart tag recognizers can recognize. To view a list of these recognizers, click Autocorrect Options on the Tools menu, and then click the Smart Tags tab.

If you have more than 65,530 terms on a worksheet and you click Check Workbook on the Smart Tags tab, some terms are not marked.

For additional information about Microsoft Application Error Reporting, click the article number below to view the article in the Microsoft Knowledge Base: 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.