Microsoft KB Archive/282163

= Ignored error flag reappears when worksheet is copied in Excel =

Article ID: 282163

Article Last Modified on 2/8/2007

-

APPLIES TO


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

-



This article was previously published under Q282163



SYMPTOMS
When you paste data from a Microsoft Excel worksheet into another Excel workbook, error indicators may appear in cells that return errors. This may occur even though you chose to ignore the errors in the original workbook.



CAUSE
This issue can occur because the Ignore Error setting is designed to be workbook-specific.



RESOLUTION
To resolve this issue, reset the error to be ignored. To ignore an error, follow these steps:
 * 1) Click the cell that contains the error indicator.
 * 2) Click the error-checking options flag. This flag appears next to a cell that has an error indicator in it.
 * 3) In the list of options, click Ignore Error.

Note You can ignore the same type of error in multiple cells by selecting a group of cells that contains the same error and then repeating steps 2 and 3. Other types of errors found in the selected range of cells will not be ignored.

Additional query words: XL2002 prb XL2003 XL2007

Keywords: kbpending kbprb KB282163

-

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

© Microsoft Corporation. All rights reserved.