Microsoft KB Archive/284884

= Unable to create or delete Smart Tags in a cell more than 255 times in Excel =

Article ID: 284884

Article Last Modified on 6/27/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q284884





SYMPTOMS
When you try to create a Smart Tag in a cell in Excel, your attempt may be unsuccessful and you may receive 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.
 * 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 in the &quot;Applies to&quot; section.



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.

Additional query words: XL2002 XL2007 XL2K7 XL2003 XL2K3

Keywords: kbbug kberrmsg kbpending KB284884

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.