XL2002: Unable to Create or Delete Smart Tags in a Cell More Than 255 Times (284884)


The information in this article applies to:

  • Microsoft Excel 2002
This article was previously published under Q284884

SYMPTOMS

When you attempt to create a Smart Tag in a cell, your attempt may be unsuccessful and generate the following error message:
Run-time error '1004':

Application-defined or object-defined error.

CAUSE

This behavior can occur if you have exceeded the maximum number of Smart Tags that a cell may contain. This behavior can occur if the following conditions are true:
  • You programmatically create or delete a Smart Tag in a cell 255 times.

    -and-
  • You do not change the cell value.

WORKAROUND

To work around this issue, change the value of the cell before you exceed the 255 Smart Tags limit. All existing Smart Tags in the cell are removed and the cell is rechecked by the loaded Smart Tag recognizers.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

The number of Smart Tags that a cell may contain is limited to 255.

NOTE: Deleted Smart Tags count toward this total limit.

For more information about Smart Tags, click Microsoft Excel Help on the Help menu, type smart tag in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MajorLast Reviewed:7/12/2001
Keywords:kbbug kberrmsg KB284884
©2002 Microsoft Corporation. All rights reserved.