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

SYMPTOMS

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)

EXCEL caused an exception 01H in module unknown at 000:0000001

Microsoft Windows 2000

The Microsoft Application Error Reporting dialog box is displayed:

Microsoft Excel has encountered a problem and needs to close. We are sorry for the inconvenience.

CAUSE

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.

WORKAROUND

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.

MORE INFORMATION

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.

REFERENCES

For additional information about Microsoft Application Error Reporting, click the article number below to view the article in the Microsoft Knowledge Base:

283768 OFFXP: End User Privacy Policy in Application Error Reporting

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.