XL2002: Ignored Error Flag Reappears When Worksheet Is Copied (282163)


The information in this article applies to:

  • Microsoft Excel 2002
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, even though you chose to ignore the errors in the original workbook.

CAUSE

This behavior 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 (the flag that appears next to a cell with 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.

Alternatively, you can use the Move or Copy feature to copy the entire worksheet into another Excel workbook and preserve the Ignore Error setting. To do this, follow these steps:
  1. On the Edit menu, click Move or Copy Sheet.
  2. In the Move or Copy dialog box, select the workbook and the location in the workbook that you want to copy the worksheet to.
  3. Click to select the Create a Copy check box.
  4. Click OK.
Modification Type:MajorLast Reviewed:3/27/2001
Keywords:kbprb KB282163
©2002 Microsoft Corporation. All rights reserved.