Green flags and other people viewing my workbook...

[charlie42]

I know that you can remove the green flags so that you cannot see them by changing "tools>options>error checking>unticking enable error checking in background", but I am looking for a way to 'Ignore Error' on all cells at once that have a Green flag so that when another user on a different PC opens the workbook they will not see the green flags even if "enable error checking in background" is checked on their version of Excel. (I am on Windows 7 using Excel 2010)

 

[shg]

I don't think you can do that unless you use a macro to turn off the user's error checking when the workbook is opened -- which would annoy me if I were that user.

 

[charlie42]

Seems you can bulk ignore them, but after closing and opening the book again on any cell that has to recalc (say from an external source) they come back :/

Select the top-left first cell in the sheet that has the green triangle indicating the error Scroll to the last bottom-right cell that has the error. Hold Shift and select that last cell Go back to that first cell, there will be a clickable icon to do something about the error Click on it and then click "Ignore Error" This will ignore all the errors in the selection you have. But you must start with the first error to get the pop-up to ignore them. <tbody> </tbody> You have to do it for each type of error (i.e. empty cells, inconsistent formula, etc...) and the error has to be the starting cell in your selection. Again the problem now is re-opening the book brings them back if the formula contains an external reference. Any thoughts?

<tbody>
</tbody>

 

[shg]

Any thoughts?

Modify the design so there are none?