Microsoft KB Archive/283667

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

Article ID: 283667

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q283667



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.

