Ignored error flag reappears when worksheet is copied in Excel

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.

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

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.