Forum Discussion
Reset error checking
Have run error checking and selected ignore error or copy formula from above. I would like to clear those settings so that running error checking again will find all of the errors.
There are several ways to hide or unhide error values and error indicators in cells.
Hide or unhide error values and error indicators in cells
If a cell contains a formula that results in an error, a triangle (an error indicator) appears in the top-left corner of the cell. You can prevent these indicators from being displayed by using the following procedure.
Cell with a formula problem
In Excel 2016, Excel 2013, and Excel 2010: Click File > Options >Formulas.
> Excel Options > Formulas
Under Error Checking, clear or Check the Enable background error checking check box.
Hope I could help you with these information / links.
I know I don't know anything (Socrates)